//public ActionResult Create() //{ // cls_HelpMethods.UserDetail(); // cls_HelpMethods.CompanyDetail(); // tbl_genMasStatus oStatus = db.tbl_genMasStatus.FirstOrDefault(p => p.status.ToLower().Contains("new")); // ViewBag.function_ID = new SelectList(db.tbl_genMasFunction.Where(p => p.isActive == true), "function_ID", "functionName"); // ViewBag.module_ID = new SelectList(db.tbl_genMasModule.Where(p => p.isActive == true), "module_ID", "moduleName"); // ViewBag.priority_ID = new SelectList(db.tbl_genMasPriority.Where(p => p.isActive == true), "priority_ID", "priority"); // ViewBag.product_ID = new SelectList(db.tbl_genMasProduct.Where(p => p.isActive == true), "product_ID", "productName"); // ViewBag.status_ID = new SelectList(db.tbl_genMasStatus.Where(p => p.isActive == true), "status_ID", "status", oStatus.status_ID); // ViewBag.taskType_ID = new SelectList(db.tbl_genMasTaskType.Where(p => p.isActive == true), "taskType_ID", "taskType"); // ViewBag.customer_ID = new SelectList(db.tbl_genCustomerMaster.Where(p => p.isDeleted == false), "customer_ID", "customerName"); // return View(); //} //[Authorize(Roles = "" + nameof(clsEnums.enumAuthencationGroups.Administrators) + "," + nameof(clsEnums.enumAuthencationGroups.Executives) + "")] //public ActionResult Create2() //{ // cls_HelpMethods.UserDetail(); // cls_HelpMethods.CompanyDetail(); // string sStatus = db.tbl_genMasStatus.FirstOrDefault(p => p.status.ToLower().Contains("new")).status_ID; // ViewBag.function_ID = new SelectList(db.tbl_genMasFunction.Where(p => p.isActive == true), "function_ID", "functionName"); // ViewBag.module_ID = new SelectList(db.tbl_genMasModule.Where(p => p.isActive == true), "module_ID", "moduleName"); // ViewBag.priority_ID = new SelectList(db.tbl_genMasPriority.Where(p => p.isActive == true), "priority_ID", "priority"); // ViewBag.product_ID = new SelectList(db.tbl_genMasProduct.Where(p => p.isActive == true), "product_ID", "productName"); // ViewBag.status_ID = new SelectList(db.tbl_genMasStatus.Where(p => p.isActive == true), "status_ID", "status", sStatus); // ViewBag.taskType_ID = new SelectList(db.tbl_genMasTaskType.Where(p => p.isActive == true), "taskType_ID", "taskType"); // ViewBag.customer_ID = new SelectList(db.tbl_genCustomerMaster.Where(p => p.isDeleted == false), "customer_ID", "customerName"); // return View(); //} //[Authorize(Roles = "" + nameof(clsEnums.enumAuthencationGroups.Administrators) + "," + nameof(clsEnums.enumAuthencationGroups.Executives) + "")] //public ActionResult Create3() //{ // cls_HelpMethods.UserDetail(); // cls_HelpMethods.CompanyDetail(); // //string sStatus = db.tbl_genMasStatus.FirstOrDefault(p => p.status.ToLower().Contains("new")).status_ID; // //ViewBag.function_ID = new SelectList(db.tbl_genMasFunction.Where(p => p.isActive == true), "function_ID", "functionName"); // //ViewBag.module_ID = new SelectList(db.tbl_genMasModule.Where(p => p.isActive == true), "module_ID", "moduleName"); // //ViewBag.priority_ID = new SelectList(db.tbl_genMasPriority.Where(p => p.isActive == true), "priority_ID", "priority"); // //ViewBag.product_ID = new SelectList(db.tbl_genMasProduct.Where(p => p.isActive == true), "product_ID", "productName"); // //ViewBag.status_ID = new SelectList(db.tbl_genMasStatus.Where(p => p.isActive == true), "status_ID", "status", sStatus); // //ViewBag.taskType_ID = new SelectList(db.tbl_genMasTaskType.Where(p => p.isActive == true), "taskType_ID", "taskType"); // //ViewBag.customer_ID = new SelectList(db.tbl_genCustomerMaster.Where(p => p.isDeleted == false), "customer_ID", "customerName"); // return View(); //} //// GET: Task/Edit/5 //[Authorize(Roles = "" + nameof(clsEnums.enumAuthencationGroups.Administrators) + "," + nameof(clsEnums.enumAuthencationGroups.Executives) + "")] //public ActionResult Edit(string task_ID) //{ // if (task_ID == null) // { // return new HttpStatusCodeResult(HttpStatusCode.BadRequest); // } // tbl_pmsTxTask tbl_pmsTxTask = db.tbl_pmsTxTask.Find(task_ID); // if (tbl_pmsTxTask == null) // { // return HttpNotFound(); // } // ViewBag.task_ID = tbl_pmsTxTask.task_ID; // ViewBag.isCancel = tbl_pmsTxTask.isCancelled; // ViewBag.customer_ID = new SelectList(db.tbl_genCustomerMaster.Where(p => p.isDeleted == false), "customer_ID", "customerName", tbl_pmsTxTask.customer_ID); // ViewBag.function_ID = new SelectList(db.tbl_genMasFunction.Where(p => p.isActive == true), "function_ID", "functionName", tbl_pmsTxTask.function_ID); // ViewBag.module_ID = new SelectList(db.tbl_genMasModule.Where(p => p.isActive == true), "module_ID", "moduleName", tbl_pmsTxTask.module_ID); // ViewBag.priority_ID = new SelectList(db.tbl_genMasPriority.Where(p => p.isActive == true), "priority_ID", "priority", tbl_pmsTxTask.priority_ID); // ViewBag.product_ID = new SelectList(db.tbl_genMasProduct.Where(p => p.isActive == true), "product_ID", "productName", tbl_pmsTxTask.product_ID); // ViewBag.status_ID = new SelectList(db.tbl_genMasStatus.Where(p => p.isActive == true), "status_ID", "status", tbl_pmsTxTask.status_ID); // ViewBag.taskType_ID = new SelectList(db.tbl_genMasTaskType.Where(p => p.isActive == true), "taskType_ID", "taskType", tbl_pmsTxTask.taskType_ID); // return View(tbl_pmsTxTask); //} //[Authorize(Roles = "" + nameof(clsEnums.enumAuthencationGroups.Administrators) + "," + nameof(clsEnums.enumAuthencationGroups.Executives) + "")] //public ActionResult Edit2(string task_ID) //{ // if (task_ID == null) // { // return new HttpStatusCodeResult(HttpStatusCode.BadRequest); // } // tbl_pmsTxTask tbl_pmsTxTask = db.tbl_pmsTxTask.Find(task_ID); // if (tbl_pmsTxTask == null) // { // return HttpNotFound(); // } // ViewBag.task_ID = tbl_pmsTxTask.task_ID; // ViewBag.isCancel = tbl_pmsTxTask.isCancelled; // ViewBag.customer_ID = new SelectList(db.tbl_genCustomerMaster, "customer_ID", "customerName", tbl_pmsTxTask.customer_ID); // ViewBag.function_ID = new SelectList(db.tbl_genMasFunction, "function_ID", "functionName", tbl_pmsTxTask.function_ID); // ViewBag.module_ID = new SelectList(db.tbl_genMasModule, "module_ID", "moduleName", tbl_pmsTxTask.module_ID); // ViewBag.priority_ID = new SelectList(db.tbl_genMasPriority, "priority_ID", "priority", tbl_pmsTxTask.priority_ID); // ViewBag.product_ID = new SelectList(db.tbl_genMasProduct, "product_ID", "productName", tbl_pmsTxTask.product_ID); // ViewBag.status_ID = new SelectList(db.tbl_genMasStatus, "status_ID", "status", tbl_pmsTxTask.status_ID); // ViewBag.taskType_ID = new SelectList(db.tbl_genMasTaskType, "taskType_ID", "taskType", tbl_pmsTxTask.taskType_ID); // return View(tbl_pmsTxTask); //} //[Authorize(Roles = "" + nameof(clsEnums.enumAuthencationGroups.Administrators) + "," + nameof(clsEnums.enumAuthencationGroups.Executives) + "")] //public ActionResult Details(string task_ID) //{ // if (task_ID == null) // { // return new HttpStatusCodeResult(HttpStatusCode.BadRequest); // } // ViewBag.task_ID = task_ID; // return View(); //} #endregion #region Transaction public async Task <Tuple <bool, string, Tasks> > SaveTask(Tasks oTask) { bool status = false; string Message = ""; Tasks oReturnTask = null; try { #region Save if (sUser_ID != null && sCompany_ID != null && sCompanyBranch_ID != null) { if (oTask != null) { var ExsistsRecords = new TaskDAO(_context).TaskExists(oTask.task_ID); if (ExsistsRecords == null) { oTask.task_ID = cls_AutoCode.AutoCode((int)enumFormNames.Task); if (oTask.task_ID != null) { oReturnTask = await new TaskDAO(_context).SaveTask(oTask); status = true; Message = "Task Saved Successfully"; } else { Message = "Task ID is Empty...!"; status = false; } } else { Message = "Already Create This Task"; status = false; } } else { Message = "Null Task"; status = false; } } else { string sHeader = "Your Session is Expired"; Message = sHeader.ToUpper() + ", \nPlease Reload This Page...!"; status = false; } #endregion } catch (Exception ex) { Message = ex.Message + "\n\n" + ex.Data; status = false; } return(new Tuple <bool, string, Tasks>(status, Message, oReturnTask)); }
public async Task <Tuple <bool, string, Tasks> > UpdateTask(Tasks oTask) { bool status = false; string Message = ""; Tasks oReturnTask = null; try { #region Update if (sUser_ID != null && sCompany_ID != null && sCompanyBranch_ID != null) { if (oTask != null) { var oldRecord = new TaskDAO(_context).GetTasksDetails(oTask.task_ID); if (oldRecord != null) { oReturnTask = await new TaskDAO(_context).UpdateTask(oTask); status = true; Message = "Task Updated Successfully...!"; } else { Message = "Task Details are Empty...!"; status = false; } } else { Message = "Task Details are Empty...!"; status = false; } } else { string sHeader = "Your Session is Expired"; Message = sHeader.ToUpper() + ", \nPlease Reload This Page...!"; status = false; } #endregion } catch (Exception ex) { Message = ex.Message + "\n\n" + ex.Data; status = false; } return(new Tuple <bool, string, Tasks>(status, Message, oReturnTask)); }
public async Task <Tuple <bool, string, bool> > DeleteTask(string task_ID) { bool status = false; bool bIscancelled = false; string Message = ""; try { if (task_ID != null) { if (sUser_ID != null && sCompany_ID != null && sCompanyBranch_ID != null) { var oldRecord = new TaskDAO(_context).GetTasksDetails(task_ID); if (oldRecord != null) { bIscancelled = await new TaskDAO(_context).DeleteTask(task_ID); Message = "Task Cancelled Succefully...!"; status = true; } else { Message = "Task Details Are Empty...!"; status = false; } } else { string sHeader = "Your Session is Expired"; Message = sHeader.ToUpper() + ", \nPlease Reload This Page...!"; status = false; } } else { Message = "Task ID Empty...!"; status = false; } } catch (Exception ex) { Message = ex.Message + "\n\n" + ex.Data; status = false; } return(new Tuple <bool, string, bool>(status, Message, bIscancelled)); }