public tblInwardWO Get(int id)
{
tblInwardWO inwardData = null;
try
{
using (var dbContext = new PMSEntities())
{
inwardData = dbContext.tblInwardWOes.Where(x => x.Id == id).ToList().FirstOrDefault();
}
}
catch (Exception ex)
{
}
return(inwardData);
}
public int Update(tblInwardWO inwardData)
{
try
{
using (var dbContext = new PMSEntities())
{
dbContext.tblInwardWOes.Attach(inwardData);
dbContext.Entry(inwardData).State = EntityState.Modified;
dbContext.SaveChanges();
}
return(1);
}
catch (Exception ex)
{
return(0);
}
}
public int Insert(tblInwardWO inwardData)
{
try
{
using (var dbContext = new PMSEntities())
{
inwardData.WOId = Guid.NewGuid();
dbContext.tblInwardWOes.Add(inwardData);
dbContext.SaveChanges();
}
return(1);
}
catch (Exception ex)
{
return(0);
}
}
public JsonResult SaveIWWorkOrder()
{
int result = 0;
tblInwardWO inwardData = JsonConvert.DeserializeObject <tblInwardWO>(Request["inwardData"]);
if (Request.Files.Count > 0)
{
string folderPath = ConfigurationManager.AppSettings["InwardsPath"];
string fileName = DateTime.Now.ToString("ddMMyyyHHmmsss") + "_" + Request.Files[0].FileName;
if (!Directory.Exists(folderPath))
{
Directory.CreateDirectory(folderPath);
}
if (!string.IsNullOrEmpty(inwardData.WOPath))
{
System.IO.File.Delete(inwardData.WOPath);
}
if (!System.IO.File.Exists(folderPath + fileName))
{
Request.Files[0].SaveAs(folderPath + fileName);
inwardData.WOPath = folderPath + fileName;
}
else
{
fileName = DateTime.Now.ToString("ddMMyyyHHmmsss") + "_1_" + Request.Files[0].FileName;
Request.Files[0].SaveAs(folderPath + fileName);
inwardData.WOPath = folderPath + fileName;
}
}
if (inwardData.Id == 0)
{
result = _workOrderService.Insert(inwardData);
}
else
{
result = _workOrderService.Update(inwardData);
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
// GET: PMS/WorkOrder
public ActionResult InwardWO(int?id)
{
List <FilterEntity> listFilters = _filterService.GetFilters();
//listFilters.Add(new FilterEntity { FilterCode = "1", FilterName = "Div1", FilterType = "Division" });
//listFilters.Add(new FilterEntity { FilterCode = "2", FilterName = "Div2", FilterType = "Division" });
//listFilters.Add(new FilterEntity { FilterCode = "11", FilterName = "Project Type 1", FilterType = "ProjectType" });
//listFilters.Add(new FilterEntity { FilterCode = "22", FilterName = "Project Type 2", FilterType = "ProjectType" });
//listFilters.Add(new FilterEntity { FilterCode = "111", FilterName = "TOS1", FilterType = "TypeofService" });
//listFilters.Add(new FilterEntity { FilterCode = "222", FilterName = "TOS2", FilterType = "TypeofService" });
tblInwardWO inwardWO = null;
if (id != null)
{
inwardWO = _workOrderService.Get(id.Value);
}
else
{
inwardWO = new tblInwardWO();
}
ViewBag.Filters = listFilters;
return(View(new tblInwardWO()));
}
public int Update(tblInwardWO inwardData)
{
return(_workOrderRepository.Update(inwardData));
}
public int Insert(tblInwardWO inwardData)
{
return(_workOrderRepository.Insert(inwardData));
}
