public ResultModels DeleteUpdateCurrentSchedulerTask(SettingSchedulerTaskModels model) { try { using (var cxt = new NuWebContext()) { using (var dbContextTransaction = cxt.Database.BeginTransaction()) { try { var schedulerTaskOnStore = cxt.G_ScheduleTaskOnStore.FirstOrDefault(x => x.ScheduleTaskId == model.ID); cxt.G_ScheduleTaskOnStore.Remove(schedulerTaskOnStore); var schedulerTask = cxt.G_ScheduleTask.FirstOrDefault(x => x.Id == model.ID && x.ReportId == model.ReportId); cxt.G_ScheduleTask.Remove(schedulerTask); cxt.SaveChanges(); dbContextTransaction.Commit(); StatusResponse.IsOk = true; StatusResponse.Message = "Scheduler Task delete successful."; } catch (Exception) { dbContextTransaction.Rollback(); } } } } catch (Exception) { StatusResponse.IsOk = false; StatusResponse.Message = "Scheduler Task delete fail!!!"; } return(StatusResponse); }
public SettingSchedulerTaskModels FindById(string Id, string StoreId) { using (var cxt = new NuWebContext()) { SettingSchedulerTaskModels model = new SettingSchedulerTaskModels(); model = cxt.G_ScheduleTask.Join(cxt.G_ScheduleTaskOnStore, o => o.Id, s => s.ScheduleTaskId, (o, s) => new{ o, s }).Where(item => item.o.Id == Id && item.s.StoreId == StoreId).Select(item => new SettingSchedulerTaskModels { ID = item.o.Id, ReportId = item.o.ReportId, Email = item.o.Email, Cc = item.o.Cc, Bcc = item.o.Bcc, Hour = item.o.Hour, Minute = item.o.Minute, Enabled = item.o.Enabled, IsDaily = item.o.IsDaily, IsMonth = item.o.IsMonthly, CreatedDate = item.o.CreatedDate, CreatedUser = item.o.CreatedUser, //DayOfWeeks = item.DayOfWeeks, EmailSubject = item.o.EmailSubject, LastDateModified = item.o.LastDateModified, //LastSuccessUtc = item.o.LastSuccessUtc, LastUserModified = item.o.LastUserModified, StoreId = item.s.StoreId, Description = item.s.Description, //StoreName = item.StoreName }).FirstOrDefault(); //model.GetDateOfWeek(); return(model); } }
public ActionResult Delete(SettingSchedulerTaskModels model) { try { ResultModels result = _factory.DeleteUpdateCurrentSchedulerTask(model); if (result.IsOk) { //return RedirectToAction("Index"); } else { model.GetListReportName(); model.ReportName = model.ListNameReport.Where(o => o.Value.Equals(model.ReportId)).Select(s => s.Text).FirstOrDefault(); ModelState.AddModelError("ReportId", "Have a error when you deleted an Scheduler Report"); Response.StatusCode = (int)HttpStatusCode.BadRequest; return(PartialView("_Delete", model)); } return(new HttpStatusCodeResult(HttpStatusCode.OK)); } catch (Exception ex) { _logger.Error("SchedulerTaskModels_Delete: " + ex); ModelState.AddModelError("Name", "Have a error when you deleted an Scheduler Report"); Response.StatusCode = (int)HttpStatusCode.BadRequest; return(PartialView("_Delete", model)); } }
public PartialViewResult Delete(string id, string StoreId) { SettingSchedulerTaskModels model = GetDetail(id, StoreId); model.GetListReportName(); model.ReportName = model.ListNameReport.Where(o => o.Value.Equals(model.ReportId)).Select(s => s.Text).FirstOrDefault(); return(PartialView("_Delete", model)); }
public ResultModels UpdateCurrentSchedulerTask(SettingSchedulerTaskModels model) { try { using (var cxt = new NuWebContext()) { using (var dbContextTransaction = cxt.Database.BeginTransaction()) { try { var schedulerTask = cxt.G_ScheduleTask.FirstOrDefault(x => x.Id == model.ID && x.ReportId == model.ReportId); schedulerTask.EmailSubject = model.EmailSubject; schedulerTask.Email = model.Email; schedulerTask.Cc = model.Cc; schedulerTask.Bcc = model.Bcc; schedulerTask.Hour = model.Hour; schedulerTask.Minute = model.Minute; schedulerTask.Enabled = model.Enabled; schedulerTask.IsDaily = model.IsDaily; schedulerTask.IsMonthly = model.IsMonth; schedulerTask.LastDateModified = DateTime.Now; // for scheduler task on store var schedulerTaskOnStore = cxt.G_ScheduleTaskOnStore.FirstOrDefault(x => x.ScheduleTaskId == model.ID /*&& x.StoreId == model.StoreId*/); schedulerTaskOnStore.Id = schedulerTaskOnStore.Id; schedulerTaskOnStore.ScheduleTaskId = schedulerTask.Id; schedulerTaskOnStore.StoreId = model.StoreId; schedulerTaskOnStore.Description = model.Description; schedulerTaskOnStore.LastDateModified = DateTime.Now; cxt.SaveChanges(); dbContextTransaction.Commit(); StatusResponse.IsOk = true; StatusResponse.Message = "Scheduler Task update successful."; } catch (Exception) { dbContextTransaction.Rollback(); } } } } catch (Exception ex) { string error = ex.ToString(); StatusResponse.IsOk = false; StatusResponse.Message = "Scheduler Task update fail!!!"; } return(StatusResponse); }
public ActionResult Edit(SettingSchedulerTaskModels model) { try { //model.GetDateOfWeek(); //=============== var user = System.Web.HttpContext.Current.Session["User"] as UserSession; List <string> listOrganizationId = new List <string>(); if (user != null) { listOrganizationId = user.ListOrganizationId; } var storeName = model.GetDataStore(listOrganizationId).Where(x => x.Value == model.StoreId).Select(x => x.Text).FirstOrDefault(); model.StoreName = storeName; //string DayOfWeeks = ""; //if (Request.Form["DayOfWeeks"] == null) //{ // //ModelState.AddModelError("DayOfWeeks", "Please choose Day of week!!!"); // DayOfWeeks = Request.Form["DoW"].ToString(); //} //else //{ // DayOfWeeks = Request.Form["DayOfWeeks"].ToString(); //} //model.DayOfWeeks = DayOfWeeks; if (!ModelState.IsValid) { Response.StatusCode = (int)HttpStatusCode.BadRequest; return(PartialView("_Edit", model)); } ResultModels result = _factory.UpdateCurrentSchedulerTask(model); if (result.IsOk) // Success { //return RedirectToAction("Index"); return(new HttpStatusCodeResult(HttpStatusCode.OK)); } else //Fail { Response.StatusCode = (int)HttpStatusCode.BadRequest; return(PartialView("_Edit", model)); } } catch (Exception ex) { _logger.Error("Organization_Edit: " + ex); Response.StatusCode = (int)HttpStatusCode.BadRequest; return(PartialView("_Edit", model)); } }
public PartialViewResult Edit(string id, string StoreId) { SettingSchedulerTaskModels model = GetDetail(id, StoreId); //=============== var user = System.Web.HttpContext.Current.Session["User"] as UserSession; List <string> listOrganizationId = new List <string>(); if (user != null) { listOrganizationId = user.ListOrganizationId; } model.GetDataStore(listOrganizationId); return(PartialView("_Edit", model)); }
public ActionResult Create() { SettingSchedulerTaskModels model = new SettingSchedulerTaskModels(); //model.GetDateOfWeek(); //=============== var user = System.Web.HttpContext.Current.Session["User"] as UserSession; List <string> listOrganizationId = new List <string>(); if (user != null) { listOrganizationId = user.ListOrganizationId; } model.GetDataStore(listOrganizationId); return(View(model)); }
public ActionResult Create(SettingSchedulerTaskModels model) { try { //model.GetDateOfWeek(); //=============== var user = System.Web.HttpContext.Current.Session["User"] as UserSession; List <string> listOrganizationId = new List <string>(); if (user != null) { listOrganizationId = user.ListOrganizationId; } var storeName = model.GetDataStore(listOrganizationId).Where(x => x.Value == model.StoreId).Select(x => x.Text).FirstOrDefault(); model.StoreName = storeName; //================== if (model.ReportId == null) { ModelState.AddModelError("ReportId", "Please choose Report!!!"); } var _obj = Request.Form["ReportId"].Split(','); if (!ModelState.IsValid) { foreach (var item in _obj) { model.ListReportID.Add(item); } return(View(model)); } foreach (var item in _obj) { string _report = item; ResultModels listStatusResponses = _factory.CreateSchedulerTask(model, _report); } return(RedirectToAction("Index")); } catch (Exception ex) { _logger.Error("SettingSchedulerTask_Create: " + ex); return(new HttpStatusCodeResult(400, ex.Message)); } }
public ActionResult Index() { try { SettingSchedulerTaskViewModels model = new SettingSchedulerTaskViewModels(); SettingSchedulerTaskModels temp = new SettingSchedulerTaskModels(); temp.GetListReportName(); model.ListSchedulerTaskModels = _factory.GetData(); foreach (var item in model.ListSchedulerTaskModels) { if (temp.ListNameReport.Any()) { item.ReportName = temp.ListNameReport.Where(o => o.Value.Equals(item.ReportId)).Select(s => s.Text).FirstOrDefault(); } item.StoreName = GetStoreName(item.StoreId); } return(View(model)); } catch (Exception ex) { _logger.Error("SettingSchedulerTask_Index: " + ex); return(new HttpStatusCodeResult(400, ex.Message)); } }
public ResultModels CreateSchedulerTask(SettingSchedulerTaskModels model, string _report) { using (var cxt = new NuWebContext()) { try { var schedulerTask = cxt.G_ScheduleTask.FirstOrDefault(x => x.ReportId == _report); var schedulerTaskOnStore = cxt.G_ScheduleTaskOnStore.FirstOrDefault(x => x.StoreId == model.StoreId && x.ScheduleTaskId == model.ID); if (schedulerTask != null && schedulerTaskOnStore != null) //Update { using (var dbContextTransaction = cxt.Database.BeginTransaction()) { try { schedulerTask.Id = schedulerTask.Id; schedulerTask.ReportId = schedulerTask.ReportId; schedulerTask.EmailSubject = model.EmailSubject; schedulerTask.Email = model.Email; schedulerTask.Cc = model.Cc; schedulerTask.Bcc = model.Bcc; //schedulerTask.DayOfWeeks = model.DayOfWeeks; schedulerTask.Hour = model.Hour; schedulerTask.Minute = model.Minute; schedulerTask.Enabled = model.Enabled; schedulerTask.IsDaily = model.IsDaily; //schedulerTask.IsMonth = model.IsMonth; schedulerTask.LastDateModified = DateTime.Now; //schedulerTask.StoreId = model.StoreId; //for schedule on store schedulerTaskOnStore.Id = schedulerTaskOnStore.Id; schedulerTaskOnStore.ScheduleTaskId = schedulerTask.Id; schedulerTaskOnStore.StoreId = schedulerTaskOnStore.StoreId; schedulerTaskOnStore.Description = model.Description; schedulerTaskOnStore.CreatedDate = schedulerTaskOnStore.CreatedDate; schedulerTaskOnStore.CreatedUser = "******"; schedulerTaskOnStore.LastUserModified = "SA"; schedulerTaskOnStore.LastDateModified = DateTime.Now; cxt.SaveChanges(); dbContextTransaction.Commit(); } catch (Exception) { dbContextTransaction.Rollback(); } } } else // Insert { using (var dbContextTransaction = cxt.Database.BeginTransaction()) { try { G_ScheduleTask itemInsert = new G_ScheduleTask(); itemInsert.Id = Guid.NewGuid().ToString(); itemInsert.CreatedDate = DateTime.Now; itemInsert.CreatedUser = "******"; itemInsert.LastDateModified = DateTime.Now; //itemInsert.LastSuccessUtc = DateTime.Now; itemInsert.LastUserModified = "SA"; itemInsert.EmailSubject = model.EmailSubject; itemInsert.ReportId = _report; itemInsert.Email = model.Email; itemInsert.Cc = model.Cc; itemInsert.Bcc = model.Bcc; itemInsert.IsDaily = model.IsDaily; //itemInsert.IsMonth = model.IsMonth; itemInsert.Hour = model.Hour; itemInsert.Minute = model.Minute; itemInsert.Enabled = model.Enabled; cxt.G_ScheduleTask.Add(itemInsert); //for Schedule On Store G_ScheduleTaskOnStore itemInsertOnStore = new G_ScheduleTaskOnStore(); itemInsertOnStore.Id = Guid.NewGuid().ToString(); itemInsertOnStore.ScheduleTaskId = itemInsert.Id; itemInsertOnStore.StoreId = model.StoreId; itemInsertOnStore.Description = model.Description; itemInsertOnStore.CreatedDate = DateTime.Now; itemInsertOnStore.CreatedUser = "******"; itemInsertOnStore.LastUserModified = "SA"; itemInsertOnStore.LastDateModified = DateTime.Now; cxt.G_ScheduleTaskOnStore.Add(itemInsertOnStore); cxt.SaveChanges(); dbContextTransaction.Commit(); } catch (Exception) { dbContextTransaction.Rollback(); } } } } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { string error = string.Format("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { string error2 = string.Format("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } //throw; } } return(StatusResponse); }