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