//public async Task<TaskMapper> TaskReferences()
//{
// //cls_HelpMethods.UserDetail();
// //cls_HelpMethods.CompanyDetail();
// return new TaskMapper()
// {
// Product = await _context.tbl_genMasProduct.Where(p => p.isActive == true).ToListAsync(),
// Function = await _context.tbl_genMasFunction.Where(p => p.isActive == true).ToListAsync(),
// Module = await _context.tbl_genMasModule.Where(p => p.isActive == true).ToListAsync(),
// Priority = await _context.tbl_genMasPriority.Where(p => p.isActive == true).ToListAsync(),
// Status = await _context.tbl_genMasStatus.Where(p => p.isActive == true).ToListAsync(),
// TaskType = await _context.tbl_genMasTaskType.Where(p => p.isActive == true).ToListAsync()
// };
//}
// GET: Task/Edit/5
//public ActionResult Edit(string task_ID)
//{
// //if (task_ID == null)
// //{
// // return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
// //}
// //tbl_pmsTxTask tbl_pmsTxTask = _context.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(_context.tbl_genCustomerMaster.Where(p => p.isDeleted == false), "customer_ID", "customerName", tbl_pmsTxTask.customer_ID);
// //ViewBag.function_ID = new SelectList(_context.tbl_genMasFunction.Where(p => p.isActive == true), "function_ID", "functionName", tbl_pmsTxTask.function_ID);
// //ViewBag.module_ID = new SelectList(_context.tbl_genMasModule.Where(p => p.isActive == true), "module_ID", "moduleName", tbl_pmsTxTask.module_ID);
// //ViewBag.priority_ID = new SelectList(_context.tbl_genMasPriority.Where(p => p.isActive == true), "priority_ID", "priority", tbl_pmsTxTask.priority_ID);
// //ViewBag.product_ID = new SelectList(_context.tbl_genMasProduct.Where(p => p.isActive == true), "product_ID", "productName", tbl_pmsTxTask.product_ID);
// //ViewBag.status_ID = new SelectList(_context.tbl_genMasStatus.Where(p => p.isActive == true), "status_ID", "status", tbl_pmsTxTask.status_ID);
// //ViewBag.taskType_ID = new SelectList(_context.tbl_genMasTaskType.Where(p => p.isActive == true), "taskType_ID", "taskType", tbl_pmsTxTask.taskType_ID);
// //return View(tbl_pmsTxTask);
//}
//public ActionResult Edit2(string task_ID)
//{
// //if (task_ID == null)
// //{
// // return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
// //}
// //tbl_pmsTxTask tbl_pmsTxTask = _context.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(_context.tbl_genCustomerMaster, "customer_ID", "customerName", tbl_pmsTxTask.customer_ID);
// //ViewBag.function_ID = new SelectList(_context.tbl_genMasFunction, "function_ID", "functionName", tbl_pmsTxTask.function_ID);
// //ViewBag.module_ID = new SelectList(_context.tbl_genMasModule, "module_ID", "moduleName", tbl_pmsTxTask.module_ID);
// //ViewBag.priority_ID = new SelectList(_context.tbl_genMasPriority, "priority_ID", "priority", tbl_pmsTxTask.priority_ID);
// //ViewBag.product_ID = new SelectList(_context.tbl_genMasProduct, "product_ID", "productName", tbl_pmsTxTask.product_ID);
// //ViewBag.status_ID = new SelectList(_context.tbl_genMasStatus, "status_ID", "status", tbl_pmsTxTask.status_ID);
// //ViewBag.taskType_ID = new SelectList(_context.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 <Tasks> SaveTask(Tasks oTask)
{
string Message = "";
try
{
//DateTime dtTaskDate = DateTime.Parse(oTask.taskDate.ToString() + " " + DateTime.Now.TimeOfDay.ToString());
DateTime dtTaskDate = new DateTime(oTask.taskDate.Year, oTask.taskDate.Month, oTask.taskDate.Day, DateTime.Now.Hour, DateTime.Now.Minute, DateTime.Now.Second);
tbl_pmsTxTask tblTask = new tbl_pmsTxTask(oTask.task_ID, dtTaskDate, oTask.taskReference, oTask.remarks,
oTask.reportedDate, oTask.reportedUser_ID,
oTask.customer_ID, oTask.product_ID, oTask.module_ID, oTask.function_ID, oTask.taskType_ID, oTask.priority_ID, oTask.status_ID,
DateTime.Now, "-1",
false, sUser_ID, sUser_ID, sUser_ID, DateTime.Now, DateTime.Now, DateTime.Now, sCompany_ID, sCompanyBranch_ID);
await _context.tbl_pmsTxTask.AddAsync(tblTask);
await _context.SaveChangesAsync();
return(oTask);
}
catch (Exception ex)
{
Message = ex.Message + "\n\n" + ex.Data;
}
return(null);
}
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));
}
public tbl_pmsTxTask GetTasksDetails(string task_ID)
{
tbl_pmsTxTask List = _context.tbl_pmsTxTask.FirstOrDefault(p => p.task_ID == task_ID);
return(List);
}
public JsonResult SaveTask(Task oTask)
{
bool status = false;
string TaskID = "", Message = "";
try
{
if (ModelState.IsValid)
{
if (sUser_ID != null && sCompany_ID != null && sCompanyBranch_ID != null)
{
var ExsistsRecords = db.tbl_pmsTxTaskEstimation.FirstOrDefault(p => p.task_ID == oTask.task_ID);
if (ExsistsRecords == null)
{
oTask.task_ID = tbl_AutoCode.AutoCode((int)enumFormNames.Task);
if (oTask.task_ID != null)
{
//DateTime dtTaskDate = DateTime.Parse(oTask.taskDate.ToString() + " " + DateTime.Now.TimeOfDay.ToString());
DateTime dtTaskDate = new DateTime(oTask.taskDate.Year, oTask.taskDate.Month, oTask.taskDate.Day, DateTime.Now.Hour, DateTime.Now.Minute, DateTime.Now.Second);
tbl_pmsTxTask tblTask = new tbl_pmsTxTask(oTask.task_ID, dtTaskDate, oTask.taskReference, oTask.remarks,
oTask.reportedDate, oTask.reportedUser_ID,
oTask.customer_ID, oTask.product_ID, oTask.module_ID, oTask.function_ID, oTask.taskType_ID, oTask.priority_ID, oTask.status_ID,
DateTime.Now, clsConfig.DefaultUser,
false, sUser_ID, sUser_ID, sUser_ID, DateTime.Now, DateTime.Now, DateTime.Now, sCompany_ID, sCompanyBranch_ID);
db.tbl_pmsTxTask.Add(tblTask);
db.SaveChanges();
TaskID = oTask.task_ID;
status = true;
Message = "Task Saved Successfully";
}
else
{
Message = "Task ID is Empty...!";
status = false;
}
}
else
{
Message = "Already Create This Task";
status = false;
}
}
else
{
string sHeader = "Your Session is Expired";
Message = sHeader.ToUpper() + ", \nPlease Reload This Page...!";
status = false;
}
}
else
{
Message = "Model State Invalid...!";
status = false;
}
}
catch (Exception ex)
{
Message = ex.Message + "\n\n" + ex.Data;
status = false;
}
return(new JsonResult {
Data = new { status = status, TaskID = TaskID, Message = Message }
});
}
