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));
}
