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);
}
