public tblCorrespondence Get(int id) { tblCorrespondence correspondenceData = null; try { using (var dbContext = new PMSEntities()) { correspondenceData = dbContext.tblCorrespondences.Where(x => x.Id == id).ToList().FirstOrDefault(); } } catch (Exception ex) { } return(correspondenceData); }
public int Update(tblCorrespondence correspondenceData) { try { using (var dbContext = new PMSEntities()) { dbContext.tblCorrespondences.Attach(correspondenceData); dbContext.Entry(correspondenceData).State = EntityState.Modified; dbContext.SaveChanges(); } return(1); } catch (Exception ex) { return(0); } }
public int Insert(tblCorrespondence correspondenceData) { try { using (var dbContext = new PMSEntities()) { correspondenceData.CorrespondenceId = Guid.NewGuid(); dbContext.tblCorrespondences.Add(correspondenceData); dbContext.SaveChanges(); } return(1); } catch (Exception ex) { return(0); } }
public JsonResult SaveCorrespondence() { int result = 0; tblCorrespondence correspondenceData = JsonConvert.DeserializeObject <tblCorrespondence>(Request["correspondenceData"]); if (Request.Files.Count > 0) { string folderPath = ConfigurationManager.AppSettings["CorrespondencePath"]; string fileName = Request.Files[0].FileName; if (!Directory.Exists(folderPath)) { Directory.CreateDirectory(folderPath); } //if (!string.IsNullOrEmpty(correspondenceData.CVCompletePath)) //{ // System.IO.File.Delete(correspondenceData.CVCompletePath); //} if (!System.IO.File.Exists(folderPath + fileName)) { Request.Files[0].SaveAs(folderPath + fileName); correspondenceData.FilePath = folderPath + fileName; correspondenceData.FileName = fileName; } else { fileName = "1_" + Request.Files[0].FileName; if (!System.IO.File.Exists(folderPath + fileName)) { fileName = DateTime.Now.ToString("ddMMyyy") + "_" + Request.Files[0].FileName; } Request.Files[0].SaveAs(folderPath + fileName); correspondenceData.FilePath = folderPath + fileName; correspondenceData.FileName = fileName; } } if (correspondenceData.Id == 0) { result = _correspondenceService.Insert(correspondenceData); } else { result = _correspondenceService.Update(correspondenceData); } return(Json(result, JsonRequestBehavior.AllowGet)); }
// GET: PMS/Correspondence public ActionResult CorrespondenceData(int?id) { List <FilterEntity> listFilters = _filterService.GetFilters(); tblCorrespondence correspondanceData = null; if (id != null) { correspondanceData = _correspondenceService.Get(id.Value); } else { correspondanceData = new tblCorrespondence(); } //listFilters.Add(new FilterEntity { FilterCode = "1", FilterName = "Projectcode1", FilterType = "ProjectCode" }); //listFilters.Add(new FilterEntity { FilterCode = "2", FilterName = "Projectcode2", FilterType = "ProjectCode" }); //listFilters.Add(new FilterEntity { FilterCode = "11", FilterName = "Dep1", FilterType = "Department" }); //listFilters.Add(new FilterEntity { FilterCode = "22", FilterName = "Dep2", FilterType = "Department" }); //listFilters.Add(new FilterEntity { FilterCode = "11", FilterName = "Type1", FilterType = "Type" }); //listFilters.Add(new FilterEntity { FilterCode = "22", FilterName = "Type2", FilterType = "Type" }); ViewBag.Filters = listFilters; return(View(correspondanceData)); }
public int Update(tblCorrespondence correspondenceData) { return(_correspondenceRepository.Update(correspondenceData)); }
public int Insert(tblCorrespondence correspondenceData) { return(_correspondenceRepository.Insert(correspondenceData)); }