public ActionResult Initiate(int id, String from) { if (getCurrentUser() == null) { return(RedirectToAction("Index", "Login")); } else { Documents documents = idocuments.GetDocument(1); OverTimeRequest overTimeRequest = ioverTimeRequest.GetOverTimeRequest(id); WorkflowDetail workflow = iworkflowDetail.GetWorkFlowDetail(overTimeRequest.rq_workflow_id); int nextStatus = iworkflowDetail.getNextWorkflow(overTimeRequest.rq_workflow_id, overTimeRequest.rq_status); WorkflowDetail workflowDetail = iworkflowDetail.getWorkflowDetlByWorkflowCodeAndPriority(overTimeRequest.rq_workflow_id, nextStatus); WorkflowTracker workflowTracker = new WorkflowTracker(); workflowTracker.wt_doc_id = documents.dc_id; workflowTracker.wt_fun_doc_id = overTimeRequest.rq_id; workflowTracker.wt_status = overTimeRequest.rq_status; workflowTracker.wt_workflow_id = overTimeRequest.rq_workflow_id; workflowTracker.wt_role_id = getCurrentUser().u_role_id; workflowTracker.wt_role_description = getCurrentUser().u_role_description; workflowTracker.wt_status_to = nextStatus; workflowTracker.wt_assign_role = workflowDetail.wd_role_id; workflowTracker.wt_assigned_role_name = workflowDetail.wd_role_description; workflowTracker.wt_approve_status = "Initiate"; workflowTracker.wt_cre_by = getCurrentUser().u_id; workflowTracker.wt_cre_by_name = getCurrentUser().u_name + "-" + getCurrentUser().u_full_name; workflowTracker.wt_cre_date = DateTime.Now; iworkflowTracker.Add(workflowTracker); overTimeRequest.rq_status = nextStatus; ioverTimeRequest.Update(overTimeRequest); return(RedirectToAction(from)); } }
public ActionResult Edit(int id, OverTimeRequest overTimeRequest, string from) { string from1 = from; if (getCurrentUser() == null) { return(RedirectToAction("Index", "Login")); } else { try { OverTimeRequest Requests = ioverTimeRequest.GetOverTimeRequest(id); Requests.rq_description = overTimeRequest.rq_description; Requests.rq_dep_id = overTimeRequest.rq_dep_id; ioverTimeRequest.Update(Requests); if (from1.Equals("Approval")) { return(RedirectToAction("Approval")); } else { return(RedirectToAction(nameof(Index))); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e.Message); ViewBag.from = from; return(View()); } } }
public ActionResult UnHold(int id, string reason) { if (getCurrentUser() == null) { return(RedirectToAction("Index", "Login")); } else { OverTimeRequest overTimeRequest = ioverTimeRequest.GetOverTimeRequest(id); overTimeRequest.rq_hold_yn = "N"; overTimeRequest.rq_hold_by = getCurrentUser().u_id; overTimeRequest.rq_hold_by_name = getCurrentUser().u_name; overTimeRequest.rq_hold_date = DateTime.Now; ioverTimeRequest.Update(overTimeRequest); Hold hold = new Hold(); hold.h_doc_id = overTimeRequest.rq_doc_id; hold.h_fun_doc_id = overTimeRequest.rq_id; hold.h_reasons = reason; hold.h_type = "UnHold"; hold.h_cre_by = getCurrentUser().u_id; hold.h_cre_date = DateTime.Now; ihold.Add(hold); return(RedirectToAction(nameof(LiveMonitoring))); } }
public void Remove(int id) { OverTimeRequest overTimeRequest = db.OverTimeRequest.Find(id); db.OverTimeRequest.Remove(overTimeRequest); db.SaveChanges(); }
public ActionResult Create(OverTimeRequest overTimeRequest) { if (ModelState.IsValid) { if (getCurrentUser() == null) { return(RedirectToAction("Index", "Login")); } else { try { Documents documents = idocuments.GetDocument(1); overTimeRequest.rq_doc_id = documents.dc_id; overTimeRequest.rq_workflow_id = documents.dc_workflow_id; overTimeRequest.rq_status = 0; overTimeRequest.rq_cre_by = getCurrentUser().u_id; overTimeRequest.rq_cre_date = DateTime.Now; ioverTimeRequest.Add(overTimeRequest); return(RedirectToAction(nameof(Index))); } catch { ViewBag.DepartmentList = (idepartment.GetDepartments); return(View()); } } } else { ViewBag.DepartmentList = (idepartment.GetDepartments); return(View()); } }
public Boolean OTSaveEditDelete(OverTimeRequest ot, string Status) { Boolean res = false; try { //ObjectParameter p = new ObjectParameter("sQLMessage", typeof(string)); //using (var context = new Cubicle_EntityEntities()) //{ // context.usp_OverTimeRequest_InsertEditDel(ot.OverTimeRequestID, ot.FromDate, ot.ToDate, ot.UserID, ot.TaskID, // ot.OtHours, ot.OtJustification, Status, p); // if (Convert.ToString(p.Value) == "INSERTSUCCESS" || Convert.ToString(p.Value) == "UPDATESUCCESS" || Convert.ToString(p.Value) == "DELETESUCCESS") // res = true; //} } catch (Exception ex) { throw ex; ////bool false = BusinessLogicExceptionHandler.HandleException(ref ex); //if (false) //{ // throw ex; //} } return(res); }
public IList <usp_GetOverTimeRequestForApprove_Result> FetchApproveData(OverTimeRequest obj, int UserID) { IList <usp_GetOverTimeRequestForApprove_Result> list = null; try { //using (var context = new Cubicle_EntityEntities()) //{ // IQueryable<usp_GetOverTimeRequestForApprove_Result> query = context.usp_GetOverTimeRequestForApprove(UserID).AsQueryable<usp_GetOverTimeRequestForApprove_Result>(); // if (obj.OverTimeRequestID != 0) // query = query.Where(p => p.OverTimeRequestID == obj.OverTimeRequestID); // if (obj.FromDate != DateTime.MinValue && obj.ToDate != DateTime.MinValue) // query = query.Where(p => (( // (p.FromDate <= obj.FromDate && obj.FromDate <= p.ToDate) || // (p.FromDate <= obj.ToDate && obj.ToDate <= p.ToDate) || // (obj.FromDate <= p.FromDate && p.FromDate <= obj.ToDate) || // (obj.FromDate <= p.ToDate && p.ToDate <= obj.ToDate) // ))); // if (obj.OTStatus != string.Empty) // query = query.Where(p => p.OTStatus == obj.OTStatus).OrderByDescending(a => a.OverTimeRequestID); // list = query.ToList(); //} } catch (Exception ex) { //bool false = BusinessLogicExceptionHandler.HandleException(ref ex); if (false) { throw ex; } } return(list); }
public Result JQ_Reject(int id, string reason) { Result result = new Result(); try { OverTimeRequest overTimeRequest = ioverTimeRequest.GetOverTimeRequest(id); WorkflowDetail workflow = iworkflowDetail.GetWorkFlowDetail(overTimeRequest.rq_workflow_id); WorkflowTracker workflowTracker = new WorkflowTracker(); Documents documents = idocuments.GetDocument(1); int rolePriority = iworkflowDetail.getPriorityByRole(overTimeRequest.rq_workflow_id, getCurrentUser().u_role_id); int previousStatus = iworkflowDetail.getPreviousWorkflow(overTimeRequest.rq_workflow_id, overTimeRequest.rq_status); int previousStatusByRole = iworkflowDetail.getPreviousWorkflow(overTimeRequest.rq_workflow_id, rolePriority); if (previousStatus == previousStatusByRole) { WorkflowDetail workflowDetail = iworkflowDetail.getWorkflowDetlByWorkflowCodeAndPriority(overTimeRequest.rq_workflow_id, previousStatus); workflowTracker.wt_doc_id = documents.dc_id; workflowTracker.wt_fun_doc_id = overTimeRequest.rq_id; workflowTracker.wt_status = overTimeRequest.rq_status; workflowTracker.wt_workflow_id = overTimeRequest.rq_workflow_id; workflowTracker.wt_role_id = getCurrentUser().u_role_id; workflowTracker.wt_role_description = getCurrentUser().u_role_description; workflowTracker.wt_status_to = previousStatus; workflowTracker.wt_assign_role = workflowDetail.wd_role_id; workflowTracker.wt_assigned_role_name = workflowDetail.wd_role_description; workflowTracker.wt_approve_status = "rejected"; workflowTracker.wt_cre_by = getCurrentUser().u_id; workflowTracker.wt_cre_by_name = getCurrentUser().u_name + "-" + getCurrentUser().u_full_name; workflowTracker.wt_cre_date = DateTime.Now; iworkflowTracker.Add(workflowTracker); overTimeRequest.rq_status = previousStatus; ioverTimeRequest.Update(overTimeRequest); if (!reason.Equals("")) { Insight insight = new Insight(); insight.in_fun_doc_id = overTimeRequest.rq_id; insight.in_doc_id = overTimeRequest.rq_doc_id; insight.in_remarks = reason; insight.in_cre_by = getCurrentUser().u_id; insight.in_cre_date = DateTime.Now; iinsight.Add(insight); } result.Message = "Success"; } else { result.Message = "Already Approved Or You Have No Privilege to Approve"; } } catch (Exception ex) { result.Message = ex.Message + " " + ex.InnerException; } return(result); }
public Result JQ_Approve(int id) { Result result = new Result(); try { Documents documents = idocuments.GetDocument(1); OverTimeRequest overTimeRequest = ioverTimeRequest.GetOverTimeRequest(id); WorkflowDetail workflow = iworkflowDetail.GetWorkFlowDetail(overTimeRequest.rq_workflow_id); int nextStatus = iworkflowDetail.getNextWorkflow(overTimeRequest.rq_workflow_id, overTimeRequest.rq_status); int rolePriority = iworkflowDetail.getPriorityByRole(overTimeRequest.rq_workflow_id, getCurrentUser().u_role_id); int nextStatusbyUser = iworkflowDetail.getNextWorkflow(overTimeRequest.rq_workflow_id, rolePriority); int MinofWorkflow = iworkflowDetail.getMinOfWorkFlow(overTimeRequest.rq_workflow_id); if (nextStatus == nextStatusbyUser) { if (overTimeRequest.rq_hold_yn == "Y") { result.Message = "This Document is Hold by Someone,Click Hold Details For more Information"; return(result); } else { WorkflowDetail workflowDetail = iworkflowDetail.getWorkflowDetlByWorkflowCodeAndPriority(overTimeRequest.rq_workflow_id, nextStatus); WorkflowTracker workflowTracker = new WorkflowTracker(); workflowTracker.wt_doc_id = documents.dc_id; workflowTracker.wt_fun_doc_id = overTimeRequest.rq_id; workflowTracker.wt_status = overTimeRequest.rq_status; workflowTracker.wt_workflow_id = overTimeRequest.rq_workflow_id; workflowTracker.wt_role_id = getCurrentUser().u_role_id; workflowTracker.wt_role_description = getCurrentUser().u_role_description; workflowTracker.wt_status_to = nextStatus; workflowTracker.wt_assign_role = workflowDetail.wd_role_id; workflowTracker.wt_assigned_role_name = workflowDetail.wd_role_description; workflowTracker.wt_approve_status = "Approved"; workflowTracker.wt_cre_by = getCurrentUser().u_id; workflowTracker.wt_cre_by_name = getCurrentUser().u_name + "-" + getCurrentUser().u_full_name; workflowTracker.wt_cre_date = DateTime.Now; iworkflowTracker.Add(workflowTracker); overTimeRequest.rq_status = nextStatus; ioverTimeRequest.Update(overTimeRequest); result.Message = "Success"; } } else { result.Message = "Already Approved Or You Have No Privilege to Approve"; } } catch (Exception ex) { result.Message = ex.Message + " " + ex.InnerException; } return(result); }
public ActionResult Reject(int id, string reason) { if (getCurrentUser() == null) { return(RedirectToAction("Index", "Login")); } else { OverTimeRequest overTimeRequest = ioverTimeRequest.GetOverTimeRequest(id); WorkflowDetail workflow = iworkflowDetail.GetWorkFlowDetail(overTimeRequest.rq_workflow_id); WorkflowTracker workflowTracker = new WorkflowTracker(); Documents documents = idocuments.GetDocument(1); int rolePriority = iworkflowDetail.getPriorityByRole(overTimeRequest.rq_workflow_id, getCurrentUser().u_role_id); int previousStatus = iworkflowDetail.getPreviousWorkflow(overTimeRequest.rq_workflow_id, overTimeRequest.rq_status); int previousStatusByRole = iworkflowDetail.getPreviousWorkflow(overTimeRequest.rq_workflow_id, rolePriority); if (previousStatus == previousStatusByRole) { WorkflowDetail workflowDetail = iworkflowDetail.getWorkflowDetlByWorkflowCodeAndPriority(overTimeRequest.rq_workflow_id, previousStatus); workflowTracker.wt_doc_id = documents.dc_id; workflowTracker.wt_fun_doc_id = overTimeRequest.rq_id; workflowTracker.wt_status = overTimeRequest.rq_status; workflowTracker.wt_workflow_id = overTimeRequest.rq_workflow_id; workflowTracker.wt_role_id = getCurrentUser().u_role_id; workflowTracker.wt_role_description = getCurrentUser().u_role_description; workflowTracker.wt_status_to = previousStatus; workflowTracker.wt_assign_role = workflowDetail.wd_role_id; workflowTracker.wt_assigned_role_name = workflowDetail.wd_role_description; workflowTracker.wt_approve_status = "rejected"; workflowTracker.wt_cre_by = getCurrentUser().u_id; workflowTracker.wt_cre_by_name = getCurrentUser().u_name + "-" + getCurrentUser().u_full_name; workflowTracker.wt_cre_date = DateTime.Now; iworkflowTracker.Add(workflowTracker); overTimeRequest.rq_status = previousStatus; ioverTimeRequest.Update(overTimeRequest); if (!reason.Equals("")) { Insight insight = new Insight(); insight.in_fun_doc_id = overTimeRequest.rq_id; insight.in_doc_id = overTimeRequest.rq_doc_id; insight.in_remarks = reason; insight.in_cre_by = getCurrentUser().u_id; insight.in_cre_date = DateTime.Now; iinsight.Add(insight); } return(RedirectToAction("Approval")); } return(RedirectToAction("Approval")); } }
public ActionResult Approve(int id, String from) { if (getCurrentUser() == null) { return(RedirectToAction("Index", "Login")); } else { Documents documents = idocuments.GetDocument(1); OverTimeRequest overTimeRequest = ioverTimeRequest.GetOverTimeRequest(id); WorkflowDetail workflow = iworkflowDetail.GetWorkFlowDetail(overTimeRequest.rq_workflow_id); int nextStatus = iworkflowDetail.getNextWorkflow(overTimeRequest.rq_workflow_id, overTimeRequest.rq_status); int rolePriority = iworkflowDetail.getPriorityByRole(overTimeRequest.rq_workflow_id, getCurrentUser().u_role_id); int nextStatusbyUser = iworkflowDetail.getNextWorkflow(overTimeRequest.rq_workflow_id, rolePriority); int MinofWorkflow = iworkflowDetail.getMinOfWorkFlow(overTimeRequest.rq_workflow_id); if (nextStatus == nextStatusbyUser) { if (overTimeRequest.rq_hold_yn == "Y") { TempData["errorMessage"] = ("This Document is Hold by Someone,Click Hold Details For more Information"); return(RedirectToAction(nameof(Approval))); } else { WorkflowDetail workflowDetail = iworkflowDetail.getWorkflowDetlByWorkflowCodeAndPriority(overTimeRequest.rq_workflow_id, nextStatus); WorkflowTracker workflowTracker = new WorkflowTracker(); workflowTracker.wt_doc_id = documents.dc_id; workflowTracker.wt_fun_doc_id = overTimeRequest.rq_id; workflowTracker.wt_status = overTimeRequest.rq_status; workflowTracker.wt_workflow_id = overTimeRequest.rq_workflow_id; workflowTracker.wt_role_id = getCurrentUser().u_role_id; workflowTracker.wt_role_description = getCurrentUser().u_role_description; workflowTracker.wt_status_to = nextStatus; workflowTracker.wt_assign_role = workflowDetail.wd_role_id; workflowTracker.wt_assigned_role_name = workflowDetail.wd_role_description; workflowTracker.wt_approve_status = "Approved"; workflowTracker.wt_cre_by = getCurrentUser().u_id; workflowTracker.wt_cre_by_name = getCurrentUser().u_name + "-" + getCurrentUser().u_full_name; workflowTracker.wt_cre_date = DateTime.Now; iworkflowTracker.Add(workflowTracker); overTimeRequest.rq_status = nextStatus; ioverTimeRequest.Update(overTimeRequest); return(RedirectToAction(from)); } } else { return(RedirectToAction(from)); } } }
public async Task <OverTimeRequest> CreateNewOverTimeRequest(OverTimeRequest overTimeRequest) { try { var res = await _repository.CreateNewOverTimeRequests(overTimeRequest); return(res); } catch (Exception ex) { throw ex; } }
public async Task <string> UpdateOverTimeRequest(int id, OverTimeRequest overTimeRequest) { try { var res = await _repository.UpdateOverTimeRequests(id, overTimeRequest); return(res); } catch (Exception ex) { throw ex; } }
public async Task <OverTimeRequest> CreateNewOverTimeRequests(OverTimeRequest overTimeRequests) { try { _context.OverTimeRequests.Add(overTimeRequests); await _context.SaveChangesAsync(); return(overTimeRequests); } catch (Exception ex) { throw ex; } }
public ActionResult StartOverTime(OverTimeRequest overTimeRequest) { if (getCurrentUser() == null) { return(RedirectToAction("Index", "Login")); } else { if (overTimeRequest.rq_dep_id != 0) { try { IEnumerable <OverTimeRequest> active = ioverTimeRequest.GetMyLiveOvertimeRequest(getCurrentUser().u_id); if (active.Count() == 0) { Documents documents = idocuments.GetDocument(1); overTimeRequest.rq_doc_id = documents.dc_id; overTimeRequest.rq_workflow_id = documents.dc_workflow_id; overTimeRequest.rq_status = 0; overTimeRequest.rq_start_time = DateTime.Now; overTimeRequest.rq_end_time = null; overTimeRequest.rq_cre_for = getCurrentUser().u_id; overTimeRequest.rq_cre_by = getCurrentUser().u_id; overTimeRequest.rq_cre_date = DateTime.Now; ioverTimeRequest.Add(overTimeRequest); return(RedirectToAction(nameof(Start))); } else { TempData["errorMessage"] = "You have been Active OverTime Request!!"; return(RedirectToAction(nameof(Start))); } } catch { TempData["errorMessage"] = "Please enter all data"; ViewBag.DepartmentList = (idepartment.GetDepartments); return(RedirectToAction(nameof(Start))); } } else { TempData["errorMessage"] = "Please enter all data"; ViewBag.DepartmentList = (idepartment.GetDepartments); return(RedirectToAction(nameof(Start))); } } }
public async Task <IActionResult> CreateOverTimeRequest(OverTimeRequest overTimeRequest) { try { var response = await _service.CreateNewOverTimeRequest(overTimeRequest); if (response != null) { return(Ok(response)); } return(StatusCode(StatusCodes.Status204NoContent)); } catch (Exception ex) { throw ex; } }
public ActionResult EndWork(int id, String from) { if (getCurrentUser() == null) { return(RedirectToAction("Index", "Login")); } else { try { Documents documents = idocuments.GetDocument(1); OverTimeRequest overTimeRequest = ioverTimeRequest.GetOverTimeRequest(id); WorkflowDetail workflow = iworkflowDetail.GetWorkFlowDetail(overTimeRequest.rq_workflow_id); int nextStatus = iworkflowDetail.getNextWorkflow(overTimeRequest.rq_workflow_id, 0); WorkflowDetail workflowDetail = iworkflowDetail.getWorkflowDetlByWorkflowCodeAndPriority(overTimeRequest.rq_workflow_id, nextStatus); if (overTimeRequest.rq_status != nextStatus) { WorkflowTracker workflowTracker = new WorkflowTracker(); workflowTracker.wt_doc_id = documents.dc_id; workflowTracker.wt_fun_doc_id = overTimeRequest.rq_id; workflowTracker.wt_status = overTimeRequest.rq_status; workflowTracker.wt_workflow_id = overTimeRequest.rq_workflow_id; workflowTracker.wt_role_id = getCurrentUser().u_role_id; workflowTracker.wt_role_description = getCurrentUser().u_role_description; workflowTracker.wt_status_to = nextStatus; workflowTracker.wt_assign_role = workflowDetail.wd_role_id; workflowTracker.wt_assigned_role_name = workflowDetail.wd_role_description; workflowTracker.wt_approve_status = "WorkDone"; workflowTracker.wt_cre_by = getCurrentUser().u_id; workflowTracker.wt_cre_by_name = getCurrentUser().u_name + "-" + getCurrentUser().u_full_name; workflowTracker.wt_cre_date = DateTime.Now; iworkflowTracker.Add(workflowTracker); overTimeRequest.rq_status = nextStatus; overTimeRequest.rq_end_time = DateTime.Now; ioverTimeRequest.Update(overTimeRequest); } return(RedirectToAction(nameof(Start))); } catch (Exception ex) { TempData["errorMessage"] = ex.Message; return(RedirectToAction(nameof(Start))); } } }
public ActionResult Delete(int id, OverTimeRequest overTimeRequest) { if (getCurrentUser() == null) { return(RedirectToAction("Index", "Login")); } else { try { ioverTimeRequest.Remove(id); return(RedirectToAction(nameof(Index))); } catch { return(View()); } } }
public String UnHold(int id, string reason, int u_id) { Result result = new Result(); try { User user = iuser.GetUser(u_id); if (user != null) { OverTimeRequest overTimeRequest = ioverTimeRequest.GetOverTimeRequest(id); overTimeRequest.rq_hold_yn = null; overTimeRequest.rq_hold_by = u_id; overTimeRequest.rq_hold_by_name = user.u_name; overTimeRequest.rq_hold_date = DateTime.Now; ioverTimeRequest.Update(overTimeRequest); Hold hold = new Hold(); hold.h_doc_id = overTimeRequest.rq_doc_id; hold.h_fun_doc_id = overTimeRequest.rq_id; hold.h_reasons = reason; hold.h_type = "Unhold"; hold.h_cre_by = user.u_id; hold.h_cre_date = DateTime.Now; ihold.Add(hold); result.Objects = null; result.Message = "Success"; return(JsonConvert.SerializeObject(result)); } else { result.Objects = null; result.Message = "You have No privilage to unHold"; return(JsonConvert.SerializeObject(result)); } } catch (Exception ex) { result.Objects = null; result.Message = ex.Message; return(JsonConvert.SerializeObject(result)); } }
public async Task <string> UpdateOverTimeRequests(int id, OverTimeRequest overTimeRequests) { try { var res = await _context.OverTimeRequests.FirstOrDefaultAsync(m => m.OverTimeRequestId == id); res.EmployeeName = overTimeRequests.EmployeeName; res.Category = overTimeRequests.Category; res.StartTime = overTimeRequests.StartTime; res.EndTime = overTimeRequests.EndTime; res.Project = overTimeRequests.Project; res.Status = overTimeRequests.Status; _context.Update(res); await _context.SaveChangesAsync(); return("Updated Record"); } catch (Exception ex) { throw ex; } }
public IList <usp_GetOverTimeRequestList_Result> GetOverTimeRequestList(OverTimeRequest obj, int UserId) { IList <usp_GetOverTimeRequestList_Result> list = null; try { //using (var Context = new Cubicle_EntityEntities()) //{ // IQueryable<usp_GetOverTimeRequestList_Result> query = Context.usp_GetOverTimeRequestList(0, UserId, Convert.ToInt32(Common.ProjectStatus.Archived)).AsQueryable<usp_GetOverTimeRequestList_Result>(); // if (obj.ProjectID != 0) // query = query.Where(p => p.ProjectID == obj.ProjectID); // if (obj.OverTimeRequestID != 0) // query = query.Where(p => p.OverTimeRequestID == obj.OverTimeRequestID); // if (obj.TaskID != 0) // query = query.Where(p => p.TaskID == obj.TaskID); // if (obj.FromDate != DateTime.MinValue && obj.ToDate != DateTime.MinValue) // query = query.Where(p => (( // (p.FromDate <= obj.FromDate && obj.FromDate <= p.ToDate) || // (p.FromDate <= obj.ToDate && obj.ToDate <= p.ToDate) || // (obj.FromDate <= p.FromDate && p.FromDate <= obj.ToDate) || // (obj.FromDate <= p.ToDate && p.ToDate <= obj.ToDate) // ))); // if (obj.OTStatus != string.Empty) // query = query.Where(p => p.OTStatus == obj.OTStatus).OrderByDescending(a => a.OverTimeRequestID); // list = query.ToList(); //} } catch (Exception ex) { //bool false = BusinessLogicExceptionHandler.HandleException(ref ex); if (false) { throw ex; } } return(list); }
public string Approve(int id, String reason, int u_id) { // reason = ""; Result result = new Result(); try { User user = iuser.GetUser(u_id); Role role = irole.GetRole(user.u_role_id); Documents documents = idocuments.GetDocument(1); OverTimeRequest overTimeRequest = ioverTimeRequest.GetOverTimeRequest(id); WorkflowDetail workflow = iworkflowDetail.GetWorkFlowDetail(overTimeRequest.rq_workflow_id); int nextStatus = iworkflowDetail.getNextWorkflow(overTimeRequest.rq_workflow_id, overTimeRequest.rq_status); int rolePriority = iworkflowDetail.getPriorityByRole(overTimeRequest.rq_workflow_id, role.r_id); int nextStatusbyUser = iworkflowDetail.getNextWorkflow(overTimeRequest.rq_workflow_id, rolePriority); int MinofWorkflow = iworkflowDetail.getMinOfWorkFlow(overTimeRequest.rq_workflow_id); if (nextStatus == nextStatusbyUser) { if (overTimeRequest.rq_hold_yn == "Y") { result.Objects = null; result.Message = "You have No privilage to unHold"; return(JsonConvert.SerializeObject(result)); } else { WorkflowDetail workflowDetail = iworkflowDetail.getWorkflowDetlByWorkflowCodeAndPriority(overTimeRequest.rq_workflow_id, nextStatus); WorkflowTracker workflowTracker = new WorkflowTracker(); workflowTracker.wt_doc_id = documents.dc_id; workflowTracker.wt_fun_doc_id = overTimeRequest.rq_id; workflowTracker.wt_status = overTimeRequest.rq_status; workflowTracker.wt_workflow_id = overTimeRequest.rq_workflow_id; workflowTracker.wt_role_id = user.u_role_id; workflowTracker.wt_role_description = role.r_description; workflowTracker.wt_status_to = nextStatus; workflowTracker.wt_assign_role = workflowDetail.wd_role_id; workflowTracker.wt_assigned_role_name = workflowDetail.wd_role_description; workflowTracker.wt_approve_status = "Approved"; workflowTracker.wt_cre_by = user.u_id; workflowTracker.wt_cre_by_name = user.u_name + "-" + user.u_full_name; workflowTracker.wt_cre_date = DateTime.Now; iworkflowTracker.Add(workflowTracker); overTimeRequest.rq_status = nextStatus; ioverTimeRequest.Update(overTimeRequest); result.Objects = null; result.Message = "Success"; return(JsonConvert.SerializeObject(result)); } } else { result.Objects = null; result.Message = "You have No privilage to Approve"; return(JsonConvert.SerializeObject(result)); } } catch (Exception ex) { var st = new StackTrace(ex, true); // Get the top stack frame var frame = st.GetFrame(0); // Get the line number from the stack frame var line = frame.GetFileLineNumber(); result.Objects = null; result.Message = ex.Message + "" + line; return(JsonConvert.SerializeObject(result)); } }
public string Reject(int id, String reason, int u_id) { Result result = new Result(); try { if (reason != null) { User user = iuser.GetUser(u_id); Role role = irole.GetRole(user.u_role_id); OverTimeRequest overTimeRequest = ioverTimeRequest.GetOverTimeRequest(id); WorkflowDetail workflow = iworkflowDetail.GetWorkFlowDetail(overTimeRequest.rq_workflow_id); WorkflowTracker workflowTracker = new WorkflowTracker(); Documents documents = idocuments.GetDocument(1); int previousStatus = iworkflowDetail.getPreviousWorkflow(overTimeRequest.rq_workflow_id, overTimeRequest.rq_status); int rolePriority = iworkflowDetail.getPriorityByRole(overTimeRequest.rq_workflow_id, role.r_id); int previousStatusByRole = iworkflowDetail.getPreviousWorkflow(overTimeRequest.rq_workflow_id, rolePriority); if (previousStatus == previousStatusByRole) { WorkflowDetail workflowDetail = iworkflowDetail.getWorkflowDetlByWorkflowCodeAndPriority(overTimeRequest.rq_workflow_id, previousStatus); workflowTracker.wt_doc_id = documents.dc_id; workflowTracker.wt_fun_doc_id = overTimeRequest.rq_id; workflowTracker.wt_status = overTimeRequest.rq_status; workflowTracker.wt_workflow_id = overTimeRequest.rq_workflow_id; workflowTracker.wt_role_id = user.u_role_id; workflowTracker.wt_role_description = role.r_description; workflowTracker.wt_status_to = previousStatus; workflowTracker.wt_assign_role = workflowDetail.wd_role_id; workflowTracker.wt_assigned_role_name = workflowDetail.wd_role_description; workflowTracker.wt_approve_status = "rejected"; workflowTracker.wt_cre_by = user.u_id; workflowTracker.wt_cre_by_name = user.u_name + "-" + user.u_full_name; workflowTracker.wt_cre_date = DateTime.Now; iworkflowTracker.Add(workflowTracker); overTimeRequest.rq_status = previousStatus; ioverTimeRequest.Update(overTimeRequest); if (!reason.Equals("")) { Insight insight = new Insight(); insight.in_fun_doc_id = overTimeRequest.rq_id; insight.in_doc_id = overTimeRequest.rq_doc_id; insight.in_remarks = reason; insight.in_cre_by = user.u_id; insight.in_cre_date = DateTime.Now; iinsight.Add(insight); } result.Objects = null; result.Message = "Success"; return(JsonConvert.SerializeObject(result)); } else { result.Objects = null; result.Message = "You have no priviage"; return(JsonConvert.SerializeObject(result)); } } else { result.Objects = null; result.Message = "Please enter Remarks"; return(JsonConvert.SerializeObject(result)); } } catch (Exception ex) { /* var st = new StackTrace(ex, true); * // Get the top stack frame * var frame = st.GetFrame(0); * // Get the line number from the stack frame * var line = frame.GetFileLineNumber();*/ result.Objects = null; result.Message = ex.Message; return(JsonConvert.SerializeObject(result)); } }
public async Task <Unit> Handle(CreateOverTimeRequest_Request request, CancellationToken cancellationToken) { var employee = await dbContext.Employees.AsNoTracking().FirstOrDefaultAsync(i => i.CompanyEmail.ToLower() == request.Requestor.ToLower()); if (employee == null) { throw new NotFoundException(nameof(domain.RequestTracker), request.Requestor); } if (string.IsNullOrWhiteSpace(employee.ReportsTo)) { throw new Exception("Cannot process. User must be assigned a supervisor."); } var approvers = await dbContext.Approvers.Include(i => i.Employee).AsNoTracking().ToArrayAsync(); if (!approvers.ToList().Any()) { throw new Exception("Cannot process. Cannot find approver."); } var supervisor = approvers.FirstOrDefault(i => i.Employee.CompanyEmail.ToLower() == employee.ReportsTo.ToLower()); var limit = approvers.Where(i => i.TypeOfRequest == domain.RequestType.Overtime).Max(i => i.Level); var finalApprover = approvers.FirstOrDefault(i => i.TypeOfRequest == domain.RequestType.Overtime && i.Level == limit); var requestTracker = new RequestTracker { RequestorID = employee.ID, IsActive = true, TypeOfRequest = domain.RequestType.Overtime, }; requestTracker.ApproverList.Add(new ApprovalTracker { ApproverID = supervisor.ID, ApproverEmail = supervisor.Employee.CompanyEmail, IsActive = true, Status = null, CreatedBy = request.Requestor, ModifiedBy = request.Requestor }); requestTracker.ApproverList.Add(new ApprovalTracker { ApproverID = finalApprover.ID, ApproverEmail = finalApprover.Employee.CompanyEmail, IsActive = true, Status = null, CreatedBy = request.Requestor, ModifiedBy = request.Requestor }); var otRequest = new OverTimeRequest { Classification = request.Classification, EmployeeID = employee.ID, IsActive = true, Purpose = request.Purpose, ShiftDate = request.ShiftDate, TimeStart = request.TimeStart, TimeEnd = request.TimeEnd, Tracker = requestTracker }; dbContext.OverTimeRequests.Add(otRequest); await dbContext.SaveChangesAsync(cancellationToken); return(Unit.Value); }
public IEnumerable <OverTimeRequest> getApprovalsBySearch(int rq_dep_id, DateTime rq_start_time, DateTime rq_end_time, int role_id, int rq_cre_by, DateTime rq_cre_date, string approve, int id) { var qry = from u in db.Users where u.u_id == id select u; User currentUser = qry.FirstOrDefault(); int workflow = (from u in db.Documents where u.dc_id == 1 select u.dc_workflow_id).FirstOrDefault(); List <OverTimeRequest> result = new List <OverTimeRequest>(); var conn = db.Database.GetDbConnection(); try { conn.Open(); using (var command = conn.CreateCommand()) { string query = @"select OverTimeRequest.*,d_description rq_dep_description,b.u_name rq_cre_for_emp_id,b.u_full_name rq_cre_for_name, a.u_name+' - '+a.u_full_name rq_cre_by_name, [dbo].[getRoleByWorkflowPriority](rq_workflow_id,rq_status) rq_current_position, [dbo].[get_deduction_from_overtime](rq_id,rq_doc_id) rq_deductions, ([dbo].[fn_GetTotalWorkingHours](rq_start_time, rq_end_time)) eligible_hour from OverTimeRequest join Departments on rq_dep_id=d_id join workflowDetails on rq_workflow_id=wd_workflow_id join UserDepartments on rq_dep_id=ud_depart_id join users m on m.u_role_id=wd_role_id join Users a on rq_cre_by=a.u_id join Users b on rq_cre_for=b.u_id where 1=1 and ud_user_id = m.u_id and rq_status = wd_priority and m.u_id=" + id; if (!rq_start_time.ToString().Equals("1/1/0001 12:00:00 AM") && !rq_end_time.ToString().Equals("1/1/0001 12:00:00 AM")) { query += " and rq_start_time between '" + rq_start_time + @"' and '" + rq_end_time + @"' "; } if (rq_dep_id != 0) { query += " and rq_dep_id='" + rq_dep_id + @"'"; } if (rq_cre_by != 0) { query += " and rq_cre_by='" + rq_cre_by + @"'"; } if (!rq_cre_date.ToString().Equals("1/1/0001 12:00:00 AM")) { query += " and CONVERT(date, rq_cre_date) ='" + rq_cre_date.Date + @"'"; } command.CommandText = query; DbDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { OverTimeRequest overTimeRequest = new OverTimeRequest(); overTimeRequest.rq_id = Int32.Parse(reader["rq_id"].ToString()); overTimeRequest.rq_cre_for = Int32.Parse(reader["rq_cre_for"].ToString()); overTimeRequest.rq_cre_for_name = reader["rq_cre_for_name"].ToString(); overTimeRequest.rq_cre_for_emp_id = reader["rq_cre_for_emp_id"].ToString(); overTimeRequest.rq_workflow_id = Int32.Parse(reader["rq_workflow_id"].ToString()); overTimeRequest.rq_doc_id = Int32.Parse(reader["rq_doc_id"].ToString()); overTimeRequest.rq_description = reader["rq_description"].ToString(); overTimeRequest.rq_dep_id = Int32.Parse(reader["rq_dep_id"].ToString()); overTimeRequest.rq_dep_description = reader["rq_dep_description"].ToString(); overTimeRequest.rq_active_yn = reader["rq_active_yn"].ToString(); if (!reader["rq_end_time"].ToString().Equals("")) { overTimeRequest.rq_end_time = DateTime.Parse(reader["rq_end_time"].ToString()); } overTimeRequest.rq_start_time = DateTime.Parse(reader["rq_start_time"].ToString()); if (!reader["eligible_hour"].ToString().Equals("")) { overTimeRequest.rq_working_hours = Decimal.Parse(reader["eligible_hour"].ToString()); } if (!reader["rq_deductions"].ToString().Equals("")) { overTimeRequest.rq_deductions = Decimal.Parse(reader["rq_deductions"].ToString()); } overTimeRequest.rq_status = Int32.Parse(reader["rq_status"].ToString()); overTimeRequest.rq_current_position = reader["rq_current_position"].ToString(); if (!reader["rq_hold_by"].ToString().Equals("")) { overTimeRequest.rq_hold_by = Int32.Parse(reader["rq_hold_by"].ToString()); overTimeRequest.rq_hold_yn = reader["rq_hold_yn"].ToString(); overTimeRequest.rq_hold_date = DateTime.Parse(reader["rq_hold_date"].ToString()); } overTimeRequest.rq_remarks = reader["rq_remarks"].ToString(); overTimeRequest.rq_cre_by = Int32.Parse(reader["rq_cre_by"].ToString()); overTimeRequest.rq_cre_by_name = reader["rq_cre_by_name"].ToString(); overTimeRequest.rq_cre_date = DateTime.Parse(reader["rq_cre_date"].ToString()); result.Add(overTimeRequest); } } reader.Dispose(); } } finally { conn.Close(); } return(result); }
public IEnumerable <OverTimeRequest> GetReports(int rq_dep_id, DateTime rq_start_time, DateTime rq_end_time, int rq_role_id, int rq_cre_by, DateTime rq_cre_date, string approve) { List <OverTimeRequest> result = new List <OverTimeRequest>(); var conn = db.Database.GetDbConnection(); try { conn.Open(); using (var command = conn.CreateCommand()) { string query = @"select OverTimeRequest.*,d_description rq_dep_description,b.u_name rq_cre_for_emp_id,b.u_full_name rq_cre_for_name, a.u_name+' - '+a.u_full_name rq_cre_by_name, [dbo].[getRoleByWorkflowPriority](rq_workflow_id,rq_status) rq_current_position, [dbo].[get_deduction_from_overtime](rq_id,rq_doc_id) rq_deductions, ([dbo].[fn_GetTotalWorkingHours](rq_start_time, rq_end_time)) eligible_hour from OverTimeRequest join Departments on rq_dep_id=d_id join Users a on rq_cre_by=a.u_id join Users b on rq_cre_for=b.u_id where 1=1 "; if (!rq_start_time.ToString().Equals("1/1/0001 12:00:00 AM") && !rq_end_time.ToString().Equals("1/1/0001 12:00:00 AM")) { query += " and rq_start_time between '" + rq_start_time + @"' and '" + rq_end_time + @"' "; } if (rq_dep_id != 0) { query += " and rq_dep_id='" + rq_dep_id + @"'"; } if (rq_cre_by != 0) { query += " and rq_cre_by='" + rq_cre_by + @"'"; } if (!rq_cre_date.ToString().Equals("1/1/0001 12:00:00 AM")) { query += " and CONVERT(date, rq_cre_date) ='" + rq_cre_date.Date + @"'"; } System.Diagnostics.Debug.WriteLine(query); command.CommandText = query; DbDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { OverTimeRequest overTimeRequest = new OverTimeRequest(); overTimeRequest.rq_id = Int32.Parse(reader["rq_id"].ToString()); overTimeRequest.rq_cre_for = Int32.Parse(reader["rq_cre_for"].ToString()); overTimeRequest.rq_cre_for_name = reader["rq_cre_for_name"].ToString(); overTimeRequest.rq_cre_for_emp_id = reader["rq_cre_for_emp_id"].ToString(); overTimeRequest.rq_workflow_id = Int32.Parse(reader["rq_workflow_id"].ToString()); overTimeRequest.rq_doc_id = Int32.Parse(reader["rq_doc_id"].ToString()); overTimeRequest.rq_description = reader["rq_description"].ToString(); overTimeRequest.rq_dep_id = Int32.Parse(reader["rq_dep_id"].ToString()); overTimeRequest.rq_dep_description = reader["rq_dep_description"].ToString(); overTimeRequest.rq_active_yn = reader["rq_active_yn"].ToString(); if (!reader["rq_end_time"].ToString().Equals("")) { overTimeRequest.rq_end_time = DateTime.Parse(reader["rq_end_time"].ToString()); } overTimeRequest.rq_start_time = DateTime.Parse(reader["rq_start_time"].ToString()); overTimeRequest.rq_working_hours = Decimal.Parse(reader["rq_no_of_hours"].ToString()); overTimeRequest.rq_status = Int32.Parse(reader["rq_status"].ToString()); overTimeRequest.rq_current_position = reader["rq_current_position"].ToString(); if (!reader["rq_hold_by"].ToString().Equals("")) { overTimeRequest.rq_hold_by = Int32.Parse(reader["rq_hold_by"].ToString()); overTimeRequest.rq_hold_yn = reader["rq_hold_yn"].ToString(); overTimeRequest.rq_hold_date = DateTime.Parse(reader["rq_hold_date"].ToString()); } if (!reader["eligible_hour"].ToString().Equals("")) { overTimeRequest.rq_working_hours = Decimal.Parse(reader["eligible_hour"].ToString()); } if (!reader["rq_deductions"].ToString().Equals("")) { overTimeRequest.rq_deductions = Decimal.Parse(reader["rq_deductions"].ToString()); } overTimeRequest.rq_remarks = reader["rq_remarks"].ToString(); overTimeRequest.rq_cre_by = Int32.Parse(reader["rq_cre_by"].ToString()); overTimeRequest.rq_cre_by_name = reader["rq_cre_by_name"].ToString(); overTimeRequest.rq_cre_date = DateTime.Parse(reader["rq_cre_date"].ToString()); result.Add(overTimeRequest); } } reader.Dispose(); } } finally { conn.Close(); } return(result); }
public void Update(OverTimeRequest overTimeRequest) { db.OverTimeRequest.Update(overTimeRequest); db.SaveChanges(); }
public async Task <IActionResult> UpdateOverTimeRequest(int OverTimeRequestId, OverTimeRequest overTimeRequest) { try { var res = await _service.UpdateOverTimeRequest(OverTimeRequestId, overTimeRequest); if (res != null) { return(Ok(res)); } return(StatusCode(StatusCodes.Status204NoContent)); } catch (Exception ex) { throw; } }
public OverTimeRequest GetOverTimeRequest(int id) { OverTimeRequest overTimeRequest = db.OverTimeRequest.Find(id); return(overTimeRequest); }
public void Add(OverTimeRequest overTimeRequest) { db.OverTimeRequest.Add(overTimeRequest); db.SaveChanges(); }