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