public tblDrawing Get(int id)
{
tblDrawing data = null;
try
{
using (var dbContext = new PMSEntities())
{
data = dbContext.tblDrawings.Where(x => x.Id == id).ToList().FirstOrDefault();
}
}
catch (Exception ex)
{
}
return(data);
}
public int Update(tblDrawing data)
{
try
{
using (var dbContext = new PMSEntities())
{
dbContext.tblDrawings.Attach(data);
dbContext.Entry(data).State = EntityState.Modified;
dbContext.SaveChanges();
}
return(1);
}
catch (Exception ex)
{
return(0);
}
}
public int Insert(tblDrawing data)
{
try
{
using (var dbContext = new PMSEntities())
{
data.DrawingId = Guid.NewGuid();
dbContext.tblDrawings.Add(data);
dbContext.SaveChanges();
}
return(1);
}
catch (Exception ex)
{
return(0);
}
}
// GET: PMS/DrawingEntry
public ActionResult DrawingEntry(int?id)
{
List <FilterEntity> listFilters = _filterService.GetFilters();
ViewBag.Filters = listFilters;
tblDrawing drawingData = null;
if (id == null)
{
drawingData = new tblDrawing();
}
else
{
drawingData = _drawingService.Get(id.Value);
}
return(View(drawingData));
}
public JsonResult SaveDrawing()
{
int result = 0;
tblDrawing data = JsonConvert.DeserializeObject <tblDrawing>(Request["data"]);
if (Request.Files.Count > 0)
{
HttpFileCollectionBase files = Request.Files;
HttpPostedFileBase file = files[0];
string folderPath = ConfigurationManager.AppSettings["DrawingsPath"];
string fileName = "";
if (!Directory.Exists(folderPath))
{
Directory.CreateDirectory(folderPath);
}
if (data.IsFileAttached)
{
fileName = DateTime.Now.ToString("ddMMyyyHHmmsss") + "_" + Request.Files[0].FileName;
if (!string.IsNullOrEmpty(data.FilePath) && data.IsFileAttached)
{
System.IO.File.Delete(data.FilePath);
}
if (!System.IO.File.Exists(folderPath + fileName))
{
Request.Files[0].SaveAs(folderPath + fileName);
data.FilePath = folderPath + fileName;
data.FileName = fileName;
}
else
{
fileName = DateTime.Now.ToString("ddMMyyyHHmmsss") + "_1_" + Request.Files[0].FileName;
Request.Files[0].SaveAs(folderPath + fileName);
data.FilePath = folderPath + fileName;
data.FileName = fileName;
}
}
if (data.IsOtherFileAttached)
{
int index = 1;
if (!data.IsOtherFileAttached)
{
index = 0;
}
fileName = DateTime.Now.ToString("ddMMyyyHHmmsss") + "_" + Request.Files[index].FileName;
if (!string.IsNullOrEmpty(data.OtherFilePath) && data.IsOtherFileAttached)
{
System.IO.File.Delete(data.OtherFilePath);
}
if (!System.IO.File.Exists(folderPath + fileName))
{
Request.Files[index].SaveAs(folderPath + fileName);
data.OtherFilePath = folderPath + fileName;
data.OtherFileName = fileName;
}
else
{
fileName = DateTime.Now.ToString("ddMMyyyHHmmsss") + "_1_" + Request.Files[index].FileName;
Request.Files[index].SaveAs(folderPath + fileName);
data.OtherFilePath = folderPath + fileName;
data.OtherFileName = fileName;
}
}
}
if (data.Id == 0)
{
result = _drawingService.Insert(data);
}
else
{
result = _drawingService.Update(data);
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public int Update(tblDrawing data)
{
return(_drawingRepository.Update(data));
}
public int Insert(tblDrawing data)
{
return(_drawingRepository.Insert(data));
}
