public GeneralInformationModel GetGeneralInformationDetail(int GeneralInformationId) { if (ClientSessionData.UserClientId != 0) { GeneralInformationModel generalInformationModel = new GeneralInformationModel(); try { var GeneralInformation = _context.tblGeneralInformations.Where(x => x.GeneralInformationId == GeneralInformationId && x.Status == 1).FirstOrDefault(); if (GeneralInformation != null) { generalInformationModel.GeneralInformationId = GeneralInformation.GeneralInformationId; generalInformationModel.Title = GeneralInformation.Title; generalInformationModel.Description = GeneralInformation.Description; generalInformationModel.UploadFile = GeneralInformation.UploadFile; generalInformationModel.OldUploadFile = GeneralInformation.UploadFile; generalInformationModel.ActualUploadFile = GeneralInformation.ActualUploadFile; generalInformationModel.CreatedOn = GeneralInformation.CreatedOn != null?GeneralInformation.CreatedOn.Value.ToString("dd MMM, yyyy") : "N/A"; } } catch { } return(generalInformationModel); } else { return(null); } }
public FileResult DownloadUploadedFile(int GeneralInformationId) { string FilePath = "resources/strataboard/" + ClientSessionData.ClientStrataBoardId + "/generalinformation/"; GeneralInformationModel model = noticeBoardHelper.GetGeneralInformationDetail(GeneralInformationId); string path = AwsS3Bucket.DownloadObject2(model.UploadFile, FilePath); return(File(Path.Combine(Server.MapPath(path)), MimeMapping.GetMimeMapping(model.UploadFile), System.IO.Path.GetFileName(path))); }
public int AddUpdateGeneralInformation(GeneralInformationModel generalInformationModel) { int result = 0; try { tblGeneralInformation tblGeneralInformationDb = new tblGeneralInformation(); tblGeneralInformationDb.Title = generalInformationModel.Title; tblGeneralInformationDb.Description = generalInformationModel.Description; tblGeneralInformationDb.UploadFile = generalInformationModel.UploadFile; tblGeneralInformationDb.ActualUploadFile = generalInformationModel.ActualUploadFile; tblGeneralInformationDb.Status = 1; tblGeneralInformationDb.CreatedBy = ClientSessionData.UserClientId; tblGeneralInformationDb.CreatedOn = DateTime.UtcNow; tblGeneralInformationDb.CreatedFromIP = HttpContext.Current.Request.UserHostAddress; tblGeneralInformationDb.ModifiedBy = ClientSessionData.UserClientId; tblGeneralInformationDb.ModifiedOn = DateTime.UtcNow; tblGeneralInformationDb.ModifiedFromIP = HttpContext.Current.Request.UserHostAddress; tblGeneralInformationDb.StratasBoardId = ClientSessionData.ClientStrataBoardId; if (generalInformationModel.GeneralInformationId > 0) { tblGeneralInformationDb.GeneralInformationId = generalInformationModel.GeneralInformationId; _context.tblGeneralInformations.Attach(tblGeneralInformationDb); _context.Entry(tblGeneralInformationDb).Property(x => x.Title).IsModified = true; _context.Entry(tblGeneralInformationDb).Property(x => x.Description).IsModified = true; _context.Entry(tblGeneralInformationDb).Property(x => x.ActualUploadFile).IsModified = true; _context.Entry(tblGeneralInformationDb).Property(x => x.UploadFile).IsModified = true; _context.Entry(tblGeneralInformationDb).Property(x => x.ModifiedBy).IsModified = true; _context.Entry(tblGeneralInformationDb).Property(x => x.ModifiedOn).IsModified = true; _context.Entry(tblGeneralInformationDb).Property(x => x.ModifiedFromIP).IsModified = true; result = _context.SaveChanges(); } else { _context.tblGeneralInformations.Add(tblGeneralInformationDb); result = _context.SaveChanges(); } } catch { } return(result); }
public List <GeneralInformationModel> GetAllGeneralInformation(int BlockNumber, int BlockSize, string SearchKeyword) { if (ClientSessionData.UserClientId != 0) { int startIndex = (BlockNumber - 1) * BlockSize; List <GeneralInformationModel> generalInformationModelList = new List <GeneralInformationModel>(); try { var GeneralInformations = _context.tblGeneralInformations.Where(x => x.StratasBoardId == ClientSessionData.ClientStrataBoardId && x.Status == 1).OrderByDescending(x => x.CreatedOn).ToList(); if (!string.IsNullOrEmpty(SearchKeyword)) { GeneralInformations = _context.tblGeneralInformations.Where(x => x.StratasBoardId == ClientSessionData.ClientStrataBoardId && x.Status == 1 && (x.Title.StartsWith(SearchKeyword) || x.Description.StartsWith(SearchKeyword))).OrderByDescending(x => x.CreatedOn).ToList(); } foreach (var item in GeneralInformations) { GeneralInformationModel generalInformationModel = new GeneralInformationModel(); generalInformationModel.GeneralInformationId = item.GeneralInformationId; generalInformationModel.Title = item.Title; generalInformationModel.Description = item.Description; generalInformationModel.UploadFile = item.UploadFile; generalInformationModel.ActualUploadFile = item.ActualUploadFile; generalInformationModel.CreatedOn = item.CreatedOn != null?item.CreatedOn.Value.ToString("dd MMM, yyyy") : "N/A"; generalInformationModelList.Add(generalInformationModel); } } catch { } generalInformationModelList = generalInformationModelList.Skip(startIndex).Take(BlockSize).ToList(); return(generalInformationModelList); } else { return(null); } }
public void DownloadUploadedFile(int GeneralInformationId) { string FilePath = "resources/strataboard/" + ClientSessionData.ClientStrataBoardId + "/generalinformation"; GeneralInformationModel model = noticeBoardHelper.GetGeneralInformationDetail(GeneralInformationId); //return AwsS3Bucket.DownloadObject(model.UploadFile, FilePath); }
public ActionResult ViewGeneralInformation(int GeneralInformationId) { GeneralInformationModel model = noticeBoardHelper.GetGeneralInformationDetail(GeneralInformationId); return(PartialView("ViewGeneralInformation", model)); }
public ActionResult EditGeneralInformation(GeneralInformationModel model, HttpPostedFileBase FileUpload1) { int result = 0; string strMsg = ""; try { var imageTypes = new string[] { "image/png", "image/jpg", "image/pjpeg", "application/pdf", "application/vnd.openxmlformats-officedocument.wordprocessingml.document", "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "application/vnd.openxmlformats-officedocument.presentationml.presentation", }; if (!imageTypes.Contains(FileUpload1.ContentType)) { strMsg = "User can add the file with extension (.jpg, .png, .pdf, .docx, .pptx, .xlsx)"; } else { if (ModelState.IsValid) { model.ActualUploadFile = System.IO.Path.GetFileName(FileUpload1.FileName); model.UploadFile = Guid.NewGuid() + System.IO.Path.GetExtension(FileUpload1.FileName); result = noticeBoardHelper.AddUpdateGeneralInformation(model); string path = "~/Content/Resources/strataboard/" + ClientSessionData.ClientStrataBoardId + "/generalinformation/"; if (!Directory.Exists(Server.MapPath(path))) { Directory.CreateDirectory(Server.MapPath(path)); } string Mappedpath = Server.MapPath(path + model.UploadFile); if (result == 1) { // save the file locally FileUpload1.SaveAs(Mappedpath); // save the file on s3 int fileMapped = AwsS3Bucket.CreateFile("resources/strataboard/" + ClientSessionData.ClientStrataBoardId + "/generalinformation/" + model.UploadFile, Mappedpath); // delete the file locally if (System.IO.File.Exists(Mappedpath)) { System.IO.File.Delete(Mappedpath); } string OldProfilePath = Server.MapPath(path + model.OldUploadFile); if (System.IO.File.Exists(OldProfilePath)) { System.IO.File.Delete(OldProfilePath); } // delete the old file from s3 AwsS3Bucket.DeleteObject("resources/strataboard/" + ClientSessionData.ClientStrataBoardId + "/generalinformation/" + model.OldUploadFile); strMsg = "General Information updated successfully."; } else { strMsg = "General Information updation failed."; } } } } catch { } return(Json(new { result = result, Msg = strMsg })); }
public ActionResult AddGeneralInformation() { GeneralInformationModel model = new GeneralInformationModel(); return(PartialView("AddGeneralInformation", model)); }