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