public FacilityModel GetFacilityData(int Id) { ShomaRMEntities db = new ShomaRMEntities(); FacilityModel model = new FacilityModel(); var GetFacilityData = db.tbl_Facility.Where(p => p.FacilityID == Id).FirstOrDefault(); if (GetFacilityData != null) { model.FacilityName = GetFacilityData.FacilityName; model.PropertyID = GetFacilityData.PropertyID; model.Photo = GetFacilityData.Photo; model.Description = GetFacilityData.Description; } model.FacilityID = Id; return(model); }
public string SaveUpdateFacility(HttpPostedFileBase fb, FacilityModel model) { string filePath = ""; string fileName = ""; string sysFileName = ""; string msg = ""; ShomaRMEntities db = new ShomaRMEntities(); if (fb != null && fb.ContentLength > 0) { filePath = HttpContext.Current.Server.MapPath("~/Content/assets/img/Facility/"); DirectoryInfo di = new DirectoryInfo(filePath); if (!di.Exists) { di.Create(); } fileName = fb.FileName; sysFileName = DateTime.Now.ToFileTime().ToString() + Path.GetExtension(fb.FileName); fb.SaveAs(filePath + "//" + sysFileName); if (!string.IsNullOrWhiteSpace(fb.FileName)) { string afileName = HttpContext.Current.Server.MapPath("~/Content/assets/img/Facility/") + "/" + sysFileName; } } int userid = ShomaRM.Models.ShomaGroupWebSession.CurrentUser != null ? ShomaRM.Models.ShomaGroupWebSession.CurrentUser.UserID : 0; if (model.FacilityID == 0) { var saveFacility = new tbl_Facility() { FacilityName = model.FacilityName, PropertyID = model.PropertyID, Photo = sysFileName, Description = model.Description, CreatedByID = userid, CreatedDate = DateTime.Now.Date }; db.tbl_Facility.Add(saveFacility); db.SaveChanges(); msg = "Facility Save Successfully"; } else { string PhotoName = ""; var GetFacilityData = db.tbl_Facility.Where(p => p.FacilityID == model.FacilityID).FirstOrDefault(); PhotoName = GetFacilityData.Photo; if (PhotoName != sysFileName && sysFileName != "") { PhotoName = sysFileName; } if (GetFacilityData != null) { GetFacilityData.FacilityName = model.FacilityName; GetFacilityData.PropertyID = model.PropertyID; GetFacilityData.Photo = PhotoName; GetFacilityData.Description = model.Description; //GetFacilityData.CreatedByID = ShomaRM.Models.ShomaGroupWebSession.CurrentUser.UserID; //GetFacilityData.CreatedDate = DateTime.Now.Date; db.SaveChanges(); msg = "Facility Updated Successfully"; } } db.Dispose(); return(msg); }