// LOGIN API
@PostMapping("/auth/login")
public ResponseEntity<?> login(@RequestBody Map<String, String> req) {
    User user = service.login(
            req.get("email"),
            req.get("password")
    );
    if (user != null) {
        String roleName = userRepository.findRoleNameByUserId(user.getUserId());
        LoginResponse res = new LoginResponse();

        res.setUserId(user.getUserId());
        res.setName(user.getName());
        res.setRole(roleName);
        res.setDepartmentId(user.getDepartmentId());

        return ResponseEntity.ok(res);
    }
    return ResponseEntity
            .status(HttpStatus.UNAUTHORIZED)
            .body(Map.of("message","Invalid credentials"));
}

// incident STATUS update (BL)
public void updateIncidentStatus(int incidentId,String newStatus,int userId){
    if (newStatus == null || newStatus.isBlank()) {
        throw new IllegalArgumentException("status can't be empty");
    }
    String currentStatus = repo.getStatusByIncidentId(incidentId);

    // Status update only if different
    if (!newStatus.equals(currentStatus)) {
        repo.updateStatus(incidentId,newStatus);
        auditLogService.logAction(incidentId,"STATUS UPDATED TO " + newStatus,userId);
    }

    // SLA END MUST ALWAYS RUN WHEN STATUS = CLOSED
    if ("CLOSED".equals(newStatus)) {
        System.out.println("SLA END TRIGGERED FOR INCIDENT " + incidentId);
        incidentSlaService.endSla(incidentId);
    }
}

@Repository
public class UserRepository {
    private final JdbcTemplate jdbcTemplate;
    public UserRepository(JdbcTemplate jdbcTemplate) {
        this.jdbcTemplate = jdbcTemplate;
    }
    // CREATE USER (DB)
    public void save(User u){
        String sql = """
            INSERT INTO users(name,email,password,role_id,department_id,status)
            VALUES (?,?,?,?,?,?)
            """;
        jdbcTemplate.update(
            sql,
            u.getName(),
            u.getEmail(),
            u.getPassword(),
            u.getRoleId(),
            u.getDepartmentId(),
            u.getStatus()
        );
    }
}

import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.security.crypto.bcrypt.BCryptPasswordEncoder;
@Configuration
public class BCryptConfig {
    @Bean
    public BCryptPasswordEncoder passwordEncoder(){
        return new BCryptPasswordEncoder();
    }
    // PASSWORD ENCRYPTION
    public String encodePassword(String password){
        return passwordEncoder().encode(password);
    }
}

// ROLE-BASED ACCESS CONTROL & USER SESSION MANAGEMENT JAVASCRIPT
const role = (localStorage.getItem("role") || "").trim().toUpperCase();
const allowedRoles = [
    "REPORTER",
    "INVESTIGATOR",
    "ADMIN",
    "COMPLIANCE",
    "AUDITOR",
    "RISK MANAGER"
];
if (!allowedRoles.includes(role)) {
    alert("Unauthorized access");
    window.location.href = "login.html";
}
const userId = localStorage.getItem("userId");
const userName =localStorage.getItem("userName");
document.getElementById("navUserName").innerText = userName;
document.getElementById("navRole").innerText = role;

<!-- MAVEN DEPENDENCIES -->
<!-- spring-boot dependency -->
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>

<!-- security dependency -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-security</artifactId>
</dependency>

<!-- mysql dependency -->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-j</artifactId>
    </dependency>
</dependencies>

# ResolveX IMS
Incident Management System developed using
Spring Boot, JDBC, MySQL, HTML, CSS, JavaScript and Bootstrap.

## Features
- Role Based Access Control
- Incident Reporting
- Investigation Workflow
- CAPA Management
- SLA Tracking
- Audit Logs

## Technology Stack
- Java
- Spring Boot
- JDBC
- MySQL
- Bootstrap
- JavaScript

## Developed By
Faizan Husain
Software Developer

/* CSS STYLESHEET */
body{
    /* background-color: red; */
}
.primary-background{
    /* background: #795548!important; */
    background:#5D4037!important;
}
.secondary-background{
    background:#E9ECEF!important;
}
.profile-img{
    width:120px;
    height:120px;
    object-fit:cover;
    border:2px solid #007bff;
}

// LOAD POSTS BY CATEGORY
// short function code in AJAX JavaScript

function getPosts(cid,temp){
    $(".c-link").removeClass(
        "active"
    );
    $.ajax({
        url:"load_posts.jsp",
        data:{cid:cid},
        success:function(data){
            $("#post-container")
            .html(data);
            $(temp).addClass(
                "active"
            );
        }
    });
}

// USER ENTITY CLASS
public class User {
    private int id;
    private String name;
    private String email;
    private String password;
    private String gender;
    private String about;
    private Timestamp dateTime;
    private String profile;
    // constructor
    public User(int id, String name, String email,
    String password, String gender, String about, Timestamp dateTime){
        this.id = id;
        this.name = name;
        this.email = email;
        this.password = password;
        this.gender = gender;
        this.about = about;
        this.dateTime = dateTime;
    }
    // setters getters here
}

// SAVE BLOG POST INTO DATABASE
public boolean savePost(Post p){
    boolean f = false;
    try{
        String q = "insert into posts(pTitle,pContent,pCode,pPic,catId,userId) values(?,?,?,?,?,?)";
        PreparedStatement pstmt = con.prepareStatement(q);
        pstmt.setString(1, p.getpTitle());
        pstmt.setString(2, p.getpContent());
        pstmt.setString(3, p.getpCode());
        pstmt.setString(4, p.getpPic());
        pstmt.setInt(5, p.getCatId());
        pstmt.setInt(6, p.getUserId());
        pstmt.executeUpdate();
        f = true;
    }catch(Exception e){
        e.printStackTrace();
    }
    return f;
}

// USER LOGIN SERVLET
@WebServlet(
    "/LoginServlet"
)
public class  LoginServlet extends HttpServlet {
    protected void doPost(HttpServletRequest req,HttpServletResponse res){

        String email = req.getParameter("email");
        String password = req.getParameter("password");
        // LOGIN VALIDATION
        UserDao dao = new UserDao(ConnectionProvider.getConnection());

        User user = dao.getUserByEmailAndPassword(email,password);
    }
}

<!-- WEB APPLICATION CONFIGURATION -->
<web-app>
    <servlet>
        <servlet-name>LoginServlet</servlet-name>
        <servlet-class>com.techblog.servlets.LoginServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>LoginServlet</servlet-name>
        <url-pattern>/LoginServlet</url-pattern>
    </servlet-mapping>

    <servlet>
        <servlet-name>UserServlet</servlet-name>
        <servlet-class>com.techblog.servlets.UserServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>UserServlet</servlet-name>
        <url-pattern>/UserServlet</url-pattern>
    </servlet-mapping>
</web-app>

# ScriptJournal

Modern blog posting application
developed using JSP, Servlet,
Bootstrap, JavaScript and PostgreSQL.
## Features
- User Authentication
- Blog Posting
- Categories
- Responsive UI

## Technology Stack

Java • JSP • Servlet • PostgreSQL
Bootstrap • JavaScript

// STATISTICS ANALYSIS
private voidloadDashboard(){
    SqlConnection con = DbConnection.getConnection();
    String q = "select count(*) from customers";
    SqlCommand cmd = new SqlCommand(q, con);

    con.Open();

    int totalCustomers = (int)cmd.ExecuteScalar();
    lblCustomers.Text = totalCustomers.ToString();
    String invoiceQuery = "select count(*) from invoices";

    SqlCommand invoiceCmd = new SqlCommand(invoiceQuery,con);

    int totalInvoices = (int)invoiceCmd.ExecuteScalar();
    lblInvoices.Text = totalInvoices.ToString();
    con.Close();
}

// SQL-SERVER DB CONNECTION
public class DbConnection {
    private static SqlConnection con;
    public static SqlConnection getConnection(){
        if(con == null){
            String connectionString ="Data Source=.;Initial Catalog=AccountingDB;Integrated Security=True";
            con = new SqlConnection(connectionString);
        }
        return con;
    }
    public static void close Connection(){
        if(con != null
        ){
            con.Close();
        }
    }
}

// CUSTOMER MODEL CLASS
public class Customer {
    public int Id {
        get; set;
    }
    public string Name {
        get; set;
    }
    public string Email {
        get; set;
    }
    public string Phone {
        get; set;
    }
    public string Address {
        get; set;
    }
    public DateTime
    CreatedDate {
        get; set;
    }
}

// short version of rdlc report code
using Microsoft.Reporting.WinForms;
public void LoadGlobalComputersInvoice(string invNo)
{
    // Setup ReportViewer
    reportViewer1.LocalReport.ReportPath =
        "Reports/InvoiceReport.rdlc";
    reportViewer1.LocalReport.DataSources.Clear();
    // Add DataSources
    reportViewer1.LocalReport.DataSources.Add(new ReportDataSource(
            "dsHeader",header
        )
    );
    reportViewer1.LocalReport.DataSources.Add(new ReportDataSource(
            "dsDetails",details
        )
    );
    // Report Parameters
    ReportParameter[] para = new ReportParameter[] { \
        new ReportParameter(
            "CompanyName","Global Computers"
        )
    };
    reportViewer1.LocalReport.SetParameters(para);
    reportViewer1.RefreshReport();
}

<!-- APPLICATION CONFIGURATION -->
<configuration>
    <connectionStrings>
        <add
            name="AccountingDB"
            connectionString="Data Source=.;Initial Catalog=GlobalAccountingDB;Integrated Security=True"
            providerName="System.Data.SqlClient"
        />
    </connectionStrings>
    <startup>
        <supportedRuntime
            version="v4.0"
            sku=".NETFramework,Version=v4.8"
        />
    </startup>
</configuration>

# Global Accounting Software

Desktop accounting software developed using C#, .NET Framework,
MsSQL and RDLC Reports.

## Features
- Customer Account Managemen
- Billing and invoice generation
- Transaction and payment tracking
- Dynamic RDLC report generation
- Ledger management
- Search and filtering functionality
- Save File (Backup of Data).
- Statistics Analysis
- Send data through Whatsapp
- OTP based Authentication
- Factory Reset

## Technology Stack

C# • .NET • MsSQL • RDLC
Windows Forms • XML

Developerd by :
Faizan Husain 2023