public static void UpdatePriorityDetails(EmployeePriority empPriority) { string commandText = "UPDATE PRIORITY SET ISSUENO=@issueno, SUBJECT=@subject, STATUS=@status, COMPLETED=@completed, DEVDUEDATE=@devdue, QADUEDATE=@qadue"; string whereClause = ""; List <OleDbParameter> paramList = new List <OleDbParameter>(); empPriority.IssueNumber = (empPriority.IssueNumber == null) ? "" : empPriority.IssueNumber; empPriority.IssueSubject = (empPriority.IssueSubject == null) ? "" : empPriority.IssueSubject; empPriority.Status = (empPriority.Status == null) ? "" : empPriority.Status; empPriority.Completed = (empPriority.Completed == null) ? "0" : empPriority.Completed; empPriority.DevDueDate = (empPriority.DevDueDate == null) ? "" : empPriority.DevDueDate; empPriority.QADueDate = (empPriority.QADueDate == null) ? "" : empPriority.QADueDate; paramList.Add(new OleDbParameter("@issueno", empPriority.IssueNumber)); paramList.Add(new OleDbParameter("@subject", empPriority.IssueSubject)); paramList.Add(new OleDbParameter("@status", empPriority.Status)); paramList.Add(new OleDbParameter("@completed", empPriority.Completed)); paramList.Add(new OleDbParameter("@devdue", empPriority.DevDueDate)); paramList.Add(new OleDbParameter("@qadue", empPriority.QADueDate)); if (empPriority.EmployeeID != null) { whereClause += (whereClause == "") ? " WHERE EMPID=@empId" : " AND EMPID=@empId"; paramList.Add(new OleDbParameter("@empId", empPriority.EmployeeID)); } if (empPriority.Priority != null) { whereClause += (whereClause == "") ? " WHERE PRIORITY=@priority" : " AND PRIORITY=@priority"; paramList.Add(new OleDbParameter("@priority", empPriority.Priority)); } commandText += whereClause; DAOEmployee.ExecuteDMLCommand(commandText, paramList); }
public static void DeleteEmployeePriority(string PID) { string commandText = "DELETE FROM PRIORITY"; string whereClause = ""; List <OleDbParameter> paramList = new List <OleDbParameter>(); if (PID != null) { whereClause += (whereClause == "") ? " WHERE PID=@pid" : " AND PID=@pid"; paramList.Add(new OleDbParameter("@pid", PID)); } commandText += whereClause; DAOEmployee.ExecuteDMLCommand(commandText, paramList); }
public static void SaveUser(RegisterModel UserDetails) { string commandText = "INSERT INTO EMPLOYEES(EMPID,EMPNAME,EMAILID,USERNAME,PASS,ISMANAGER,ISACTIVE) VALUES(@empId, @empName, @emailId, @username, @pass, @IsManager, @IsActive)"; List <OleDbParameter> paramList = new List <OleDbParameter>(); paramList.Add(new OleDbParameter("@empId", UserDetails.EMPID)); paramList.Add(new OleDbParameter("@empName", UserDetails.FullName)); paramList.Add(new OleDbParameter("@emailId", UserDetails.EmailId)); paramList.Add(new OleDbParameter("@username", UserDetails.UserName)); paramList.Add(new OleDbParameter("@pass", UserDetails.Password)); paramList.Add(new OleDbParameter("@IsManager", UserDetails.IsManager)); paramList.Add(new OleDbParameter("@IsActive", "No")); DAOEmployee.ExecuteDMLCommand(commandText, paramList); }
public static void UpdateEmployeePriority(string priorityRowId, string priority) { string commandText = "UPDATE PRIORITY SET PRIORITY=@priority"; string whereClause = ""; List <OleDbParameter> paramList = new List <OleDbParameter>(); paramList.Add(new OleDbParameter("@priority", priority)); if (priorityRowId != null) { whereClause += (whereClause == "") ? " WHERE PID=@priorityRowId" : " AND PID=@priorityRowId"; paramList.Add(new OleDbParameter("@priorityRowId", priorityRowId)); } commandText += whereClause; DAOEmployee.ExecuteDMLCommand(commandText, paramList); }
public static void UpdateEmployeesFollowingPriority(string empId, int priority) { string commandText = "UPDATE PRIORITY SET PRIORITY=PRIORITY-1"; string whereClause = ""; List <OleDbParameter> paramList = new List <OleDbParameter>(); if (empId != null) { whereClause += (whereClause == "") ? " WHERE EMPID=@empId" : " AND EMID=@empId"; paramList.Add(new OleDbParameter("@empId", empId)); } if (priority > 0) { whereClause += (whereClause == "") ? " WHERE PRIORITY>@priority" : " AND PRIORITY>@priority"; paramList.Add(new OleDbParameter("@priority", priority)); } commandText += whereClause; DAOEmployee.ExecuteDMLCommand(commandText, paramList); }
/*public static EmployeePriority EditEmployeePriority(string PID) * { * EmployeePriority empPriority = null; * DataTable dtPriority = GetEmployeePriorityById(PID); * if (dtPriority.Rows.Count > 0) * { * empPriority = new EmployeePriority(); * empPriority.EmployeeID = dtPriority.Rows[0]["EMPID"].ToString(); ; * empPriority.EmployeeName = dtPriority.Rows[0]["EMPNAME"].ToString(); * empPriority.IssueNumber = dtPriority.Rows[0]["ISSUENO"].ToString(); * empPriority.IssueSubject = dtPriority.Rows[0]["SUBJECT"].ToString(); * empPriority.DevDueDate = dtPriority.Rows[0]["DEVDUEDATE"].ToString().Split(' ')[0]; * empPriority.QADueDate = dtPriority.Rows[0]["QADUEDATE"].ToString().Split(' ')[0]; * empPriority.Priority = dtPriority.Rows[0]["PRIORITY"].ToString(); * } * return empPriority; * }*/ public static void AddPriority(EmployeePriority empPriority) { string commandText = "INSERT INTO PRIORITY(EMPID,ISSUENO,SUBJECT,STATUS,COMPLETED,DEVDUEDATE,QADUEDATE,PRIORITY,ENTEREDBY,ASSIGNEDBY) VALUES(@empId,@issueno,@subject,@status,@completed,@devdue,@qadue,@priority,@enteredby,@assignedby)"; List <OleDbParameter> paramList = new List <OleDbParameter>(); empPriority.Completed = (empPriority.Completed == null) ? "0" : empPriority.Completed; empPriority.DevDueDate = (empPriority.DevDueDate == null) ? "" : empPriority.DevDueDate; empPriority.QADueDate = (empPriority.QADueDate == null) ? "" : empPriority.QADueDate; paramList.Add(new OleDbParameter("@empId", empPriority.EmployeeID)); paramList.Add(new OleDbParameter("@issueno", empPriority.IssueNumber)); paramList.Add(new OleDbParameter("@subject", empPriority.IssueSubject)); paramList.Add(new OleDbParameter("@status", empPriority.Status)); paramList.Add(new OleDbParameter("@completed", empPriority.Completed)); paramList.Add(new OleDbParameter("@devdue", empPriority.DevDueDate)); paramList.Add(new OleDbParameter("@qadue", empPriority.QADueDate)); paramList.Add(new OleDbParameter("@priority", empPriority.Priority)); paramList.Add(new OleDbParameter("@enteredby", empPriority.EnteredBy)); paramList.Add(new OleDbParameter("@assignedby", empPriority.AssignedBy)); DAOEmployee.ExecuteDMLCommand(commandText, paramList); }
public static void AssignEmployeePriority(string assignedBy, string assignTo, string pid, string status, string reason) { string commandText = "UPDATE PRIORITY SET EMPID=@empid, STATUS=@status, ASSIGNEDBY=@assignedby, REASON=@reason, PRIORITY=@priority"; string whereClause = ""; List <OleDbParameter> paramList = new List <OleDbParameter>(); paramList.Add(new OleDbParameter("@empid", assignTo)); paramList.Add(new OleDbParameter("@status", status)); paramList.Add(new OleDbParameter("@assignedby", assignedBy)); paramList.Add(new OleDbParameter("@reason", reason)); string strPriority = (GetEmployeeMaxPriority(assignTo)); int priority = (strPriority == "") ? 1 : (Convert.ToInt32(strPriority) + 1); paramList.Add(new OleDbParameter("@priority", priority)); if (pid != null) { whereClause += (whereClause == "") ? " WHERE PID=@pid" : " AND PID=@pid"; paramList.Add(new OleDbParameter("@pid", pid)); } commandText += whereClause; DAOEmployee.ExecuteDMLCommand(commandText, paramList); }