public CommunityActivityModel SaveUploadAttachFileCommunityActivity(HttpPostedFileBase fileBaseUpload, CommunityActivityModel model) { ShomaRMEntities db = new ShomaRMEntities(); CommunityActivityModel _CommunityActivityModel = new CommunityActivityModel(); string filePath = ""; string fileName = ""; string sysFileName = ""; string Extension = ""; if (fileBaseUpload != null && fileBaseUpload.ContentLength > 0) { filePath = HttpContext.Current.Server.MapPath("~/Content/assets/img/CommunityPostFiles/"); DirectoryInfo di = new DirectoryInfo(filePath); FileInfo _FileInfo = new FileInfo(filePath); if (!di.Exists) { di.Create(); } fileName = fileBaseUpload.FileName; Extension = Path.GetExtension(fileBaseUpload.FileName); sysFileName = DateTime.Now.ToFileTime().ToString() + Path.GetExtension(fileBaseUpload.FileName); fileBaseUpload.SaveAs(filePath + "//" + sysFileName); if (!string.IsNullOrWhiteSpace(fileBaseUpload.FileName)) { string afileName = HttpContext.Current.Server.MapPath("~/Content/assets/img/CommunityPostFiles/") + "/" + sysFileName; } _CommunityActivityModel.AttatchFile = sysFileName; _CommunityActivityModel.AttachFileOriginalName = fileName; } return(_CommunityActivityModel); }
public List <CommunityActivityModel> GetCommunityActivityAdminList(CommunityActivityModel model) { ShomaRMEntities db = new ShomaRMEntities(); List <CommunityActivityModel> list = new List <CommunityActivityModel>(); var getCommunityActivity = db.tbl_CommunityActivity.Where(co => co.TenantId == model.TenantId).OrderByDescending(co => co.CID).ToList(); if (getCommunityActivity != null) { foreach (var item in getCommunityActivity) { var tenantProfile = db.tbl_TenantInfo.Where(co => co.TenantID == item.TenantId).FirstOrDefault(); if (tenantProfile != null) { list.Add(new CommunityActivityModel() { CID = item.CID, TenantId = item.TenantId, Details = item.Details, AttatchFile = item.AttatchFile, AttachFileOriginalName = item.AttachFileOriginalName, DateString = item.Date.Value.ToString("MM/dd/yyyy"), TenantName = tenantProfile.FirstName + " " + tenantProfile.LastName, ProfilePicture = tenantProfile.ProfilePicture, OrginalProfilePicture = tenantProfile.OrginalProfilePicture }); } } } db.Dispose(); return(list); }
public void DeleteCommunityActivityPost(CommunityActivityModel model) { ShomaRMEntities db = new ShomaRMEntities(); var CommunityActivityPost = db.tbl_CommunityActivity.Where(p => p.CID == model.CID).FirstOrDefault(); if (CommunityActivityPost != null) { db.tbl_CommunityActivity.Remove(CommunityActivityPost); db.SaveChanges(); } }
public string SaveUpdateCommunityPost(CommunityActivityModel model) { string msg = ""; ShomaRMEntities db = new ShomaRMEntities(); if (model.CID == 0) { var saveCommunityActivity = new tbl_CommunityActivity(); { saveCommunityActivity.TenantId = model.TenantId; saveCommunityActivity.Details = model.Details == null ? "" : model.Details.Trim(); saveCommunityActivity.AttatchFile = model.AttatchFile; saveCommunityActivity.Date = DateTime.Now; saveCommunityActivity.AttachFileOriginalName = model.AttachFileOriginalName; }; db.tbl_CommunityActivity.Add(saveCommunityActivity); db.SaveChanges(); msg = "Posted Successfully"; } else { var updateCommunityActivity = db.tbl_CommunityActivity.Where(co => co.CID == model.CID).FirstOrDefault(); if (updateCommunityActivity != null) { updateCommunityActivity.TenantId = model.TenantId; updateCommunityActivity.Details = model.Details.Trim() == string.Empty ? " " : model.Details.Trim(); updateCommunityActivity.AttatchFile = model.AttatchFile; updateCommunityActivity.Date = model.Date; updateCommunityActivity.AttachFileOriginalName = model.AttachFileOriginalName; db.SaveChanges(); } } db.Dispose(); return(msg); }