public CUSTOMREGION Add(CUSTOMREGION model) { var dc = new eprocdbDataContext(); dc.CUSTOMREGIONs.InsertOnSubmit(model); dc.SubmitChanges(); return(model); }
public ActionResult Edit(string regionId, CUSTOMREGION model) { try { IRegionService svc = new RegionService(); var result = svc.Edit(regionId, model); return(RedirectToAction("Index")); } catch (Exception ex) { general.AddLogError("Region Edit", ex.Message, ex.StackTrace); return(View("~/Views/Master/Region/Index.cshtml")); } }
public CUSTOMREGION Edit(string regionId, CUSTOMREGION model) { var dc = new eprocdbDataContext(); var md = (from c in dc.CUSTOMREGIONs where c.REGIONID == regionId select c).SingleOrDefault(); md.REGIONNAME = model.REGIONNAME; if (model.STATUS != null) { md.STATUS = model.STATUS; } else { md.STATUS = md.STATUS; } dc.SubmitChanges(); return(model); }
public ActionResult Add(CUSTOMREGION model) { try { IRegionService svc = new RegionService(); var result = svc.Add(model); this.AddNotification("Your Data Has Been Successfully Saved. ", NotificationType.SUCCESS); return(RedirectToAction("Index")); } catch (Exception ex) { general.AddLogError("Region Add", ex.Message, ex.StackTrace); this.AddNotification("ID exist", NotificationType.ERROR); this.ViewBag.Status = new SelectList(this.GetStatus(), "Key", "Value"); return(View("~/Views/Master/Region/Add.cshtml")); } }
public ActionResult Download(CUSTOMREGION model) { try { XLWorkbook xlWorkBook = new XLWorkbook(); var xlWorkSheet = xlWorkBook.Worksheets.Add("Master Region");// xlWorkSheet; xlWorkSheet.Cell(1, 1).Value = "RegionId"; xlWorkSheet.Cell(1, 2).Value = "RegionName"; xlWorkSheet.Cell(1, 3).Value = "IsActive"; IRegionService svc = new RegionService(); var Data = svc.GetAll(); int Row = 2; if (Data.Count > 0) { for (int i = 0; i < Data.Count; i++) { xlWorkSheet.Cell(Row + i, 1).Value = Data[i].REGIONID; xlWorkSheet.Cell(Row + i, 2).Value = Data[i].REGIONNAME; xlWorkSheet.Cell(Row + i, 3).Value = Data[i].STATUS; } xlWorkSheet.Columns().AdjustToContents(); var path = Server.MapPath("..") + "\\Master-Region.xlsx"; xlWorkBook.SaveAs(path); xlWorkBook.Dispose(); return(File(path, "application/vnd.ms-excel", "Master-Region.xlsx")); } return(RedirectToAction("Index")); } catch (Exception ex) { general.AddLogError("CompanyCode Download", ex.Message, ex.StackTrace); return(View("~/Views/Master/CompanyCode/Index.cshtml", model)); } }