public ActionResult Detail(int id) { SBH_TM_SOSMED sosmedView = new SBH_TM_SOSMED(); SBH_TM_SOSMED sosmedRes = new SBH_TM_SOSMED(); sosmedView.ID = id; sosmedRes = repo.Retrived(id); return(PartialView(sosmedRes)); }
public ActionResult Edit(int id) { SBH_TM_SOSMED sosmedView = new SBH_TM_SOSMED(); SBH_TM_SOSMED sosmedRes = new SBH_TM_SOSMED(); sosmedView.ID = id; ViewBag.GetTypeSosmedList = Dropdown.GetTypeSosmedList(); ViewBag.GetTrueFalse = Dropdown.GetTrueFalse(); sosmedRes = repo.Retrived(id); return(PartialView(sosmedRes)); }
public ResultStatus Delete(int id) { ResultStatus rs = new ResultStatus(); try { SBH_TM_SOSMED a = _ctx.SBH_TM_SOSMED.Find(id); a.ROW_STATUS = fn.fg.NotActive; _ctx.Entry(a).State = System.Data.Entity.EntityState.Modified; rs.SetSuccessStatus("Data has been deleted successfully"); } catch (Exception ex) { rs.SetErrorStatus(ex.Message); } return(rs); }
public SBH_TM_SOSMED Retrived(int id) { try { SBH_TM_SOSMED oA = new SBH_TM_SOSMED(); SBH_TM_SOSMED oB = _ctx.SBH_TM_SOSMED .Where(x => x.ROW_STATUS == fn.fg.IsActive && x.ID == id).FirstOrDefault(); if (oB != null) { oA.ID = oB.ID; oA.TYPE = oB.TYPE; oA.NAME = oB.NAME; oA.DESCRIPTION = oB.DESCRIPTION; oA.ICON = oB.ICON; oA.URL = oB.URL; oA.DATA_EMBED = oB.DATA_EMBED; oA.HEIGHT = oB.HEIGHT; oA.WIDTH = oB.WIDTH; oA.DATA_WIDGET_ID = oB.DATA_WIDGET_ID; oA.PHOTO_PATH = oB.PHOTO_PATH; oA.BANNER_SELECTED = oB.BANNER_SELECTED; oA.CREATED_TIME = oB.CREATED_TIME; oA.CREATED_BY = oB.CREATED_BY; oA.LAST_MODIFIED_TIME = oB.LAST_MODIFIED_TIME; oA.LAST_MODIFIED_BY = oB.LAST_MODIFIED_BY; oA.ROW_STATUS = oB.ROW_STATUS; return(oA); } else { return(null); } } catch (Exception ex) { return(null); throw new Exception(ex.Message); } }
public ActionResult ActionCreate(SBH_TM_SOSMED sosmedView, HttpPostedFileBase postedFile) { try { string physicalPath = ""; if (postedFile != null) { string ImageName = System.IO.Path.GetFileName(postedFile.FileName); //file2 to store path and url physicalPath = Server.MapPath("~" + Common.GetPathFolderImg() + ImageName); sosmedView.PHOTO_PATH = Common.GetPathFolderImg() + ImageName; } sosmedView.LAST_MODIFIED_BY = Session["UserId"].ToString(); sosmedView.LAST_MODIFIED_TIME = DateTime.Now; rs = repo.Add(sosmedView); if (rs.IsSuccess) { if (physicalPath != "") { postedFile.SaveAs(physicalPath); } rs.SetSuccessStatus("Data has been created successfully"); TempData["msgSuccess"] = rs.MessageText; } else { rs.SetErrorStatus("Data failed to created"); TempData["msgError"] = rs.MessageText; } } catch (Exception ex) { ModelState.AddModelError("", ex.Message); rs.SetErrorStatus("Data failed to created"); TempData["msgError"] = rs.MessageText; } return(RedirectToAction("Index")); }
public ResultStatus Edit(int id, SBH_TM_SOSMED par) { ResultStatus rs = new ResultStatus(); try { SBH_TM_SOSMED a = _ctx.SBH_TM_SOSMED.Find(id); if (a != null) { a.ID = par.ID; a.TYPE = par.TYPE; a.NAME = par.NAME; a.DESCRIPTION = par.DESCRIPTION; a.ICON = par.ICON; a.URL = par.URL; a.DATA_EMBED = par.DATA_EMBED; a.HEIGHT = par.HEIGHT; a.WIDTH = par.WIDTH; a.DATA_WIDGET_ID = par.DATA_WIDGET_ID; a.PHOTO_PATH = par.PHOTO_PATH; a.BANNER_SELECTED = par.BANNER_SELECTED; a.LAST_MODIFIED_TIME = DateTime.Now; a.LAST_MODIFIED_BY = "System"; _ctx.Entry(a).State = System.Data.Entity.EntityState.Modified; _ctx.SaveChanges(); rs.SetSuccessStatus("Data has been created successfully"); } } catch (Exception ex) { rs.SetErrorStatus(ex.Message); } return(rs); }
public List <SBH_TM_SOSMED> RetrivedBannerSelected() { try { List <SBH_TM_SOSMED> lA = new List <SBH_TM_SOSMED>(); foreach (var item in _ctx.SBH_TM_SOSMED .Where(x => x.ROW_STATUS == fn.fg.IsActive && x.BANNER_SELECTED == 1)) { SBH_TM_SOSMED oA = new SBH_TM_SOSMED(); oA.ID = item.ID; oA.TYPE = item.TYPE; oA.NAME = item.NAME; oA.DESCRIPTION = item.DESCRIPTION; oA.ICON = item.ICON; oA.URL = item.URL; oA.DATA_EMBED = item.DATA_EMBED; oA.HEIGHT = item.HEIGHT; oA.WIDTH = item.WIDTH; oA.DATA_WIDGET_ID = item.DATA_WIDGET_ID; oA.PHOTO_PATH = item.PHOTO_PATH; oA.BANNER_SELECTED = item.BANNER_SELECTED; oA.CREATED_TIME = item.CREATED_TIME; oA.CREATED_BY = item.CREATED_BY; oA.LAST_MODIFIED_TIME = item.LAST_MODIFIED_TIME; oA.LAST_MODIFIED_BY = item.LAST_MODIFIED_BY; oA.ROW_STATUS = item.ROW_STATUS; lA.Add(oA); } return(lA); } catch (Exception ex) { throw new Exception(ex.Message); } }
public ResultStatus Add(SBH_TM_SOSMED par) { ResultStatus rs = new ResultStatus(); try { SBH_TM_SOSMED a = new SBH_TM_SOSMED() { ID = par.ID, TYPE = par.TYPE, NAME = par.NAME, DESCRIPTION = par.DESCRIPTION, ICON = par.ICON, URL = par.URL, DATA_EMBED = par.DATA_EMBED, HEIGHT = par.HEIGHT, WIDTH = par.WIDTH, DATA_WIDGET_ID = par.DATA_WIDGET_ID, PHOTO_PATH = par.PHOTO_PATH, BANNER_SELECTED = par.BANNER_SELECTED, CREATED_TIME = DateTime.Now, CREATED_BY = "System", ROW_STATUS = fn.fg.IsActive }; _ctx.SBH_TM_SOSMED.Add(a); _ctx.SaveChanges(); rs.SetSuccessStatus("Data has been created successfully"); } catch (Exception ex) { rs.SetErrorStatus(ex.Message); } return(rs); }