public SysModalGlobal.CResutlWebMethod DeleteData(string str)
{
PTTGSP_DWSContext db = new PTTGSP_DWSContext();
SysModalGlobal.CResutlWebMethod result = new SysModalGlobal.CResutlWebMethod();
try
{
if (!String.IsNullOrEmpty(str))
{
var data = str.Split(',').Select(Int32.Parse).ToList();
var lstWorkMate = db.TB_Work_Material.Where(w => data.Contains(w.nWorkID)).ToList();
foreach (var item in lstWorkMate)
{
db.TB_Work_Material.Remove(item);
}
db.SaveChanges();
var lstnID = db.TB_Work.Where(w => !w.IsDel).ToList();
var lstData = lstnID.Where(w => data.Contains(w.nWorkID)).ToList();
lstData.ForEach(f => f.IsDel = true);
db.SaveChanges();
result.sStatus = SysFunc.process_Success;
}
}
catch (Exception e)
{
result.sStatus = SysFunc.process_Error;
result.sMsg = e.Message;
}
return(result);
}
public SysModalGlobal.CResutlWebMethod DeleteData(string str)
{
PTTGSP_DWSContext db = new PTTGSP_DWSContext();
SysModalGlobal.CResutlWebMethod result = new SysModalGlobal.CResutlWebMethod();
try
{
if (!String.IsNullOrEmpty(str))
{
var data = str.Split(',').Select(Int32.Parse).ToList();
var lstnID = db.TB_Material_Location.Where(w => !w.IsDel).ToList();
var lstMaterial = db.TB_Materials.Where(w => !w.IsDel).ToList();
var lstData = lstnID.Where(w => data.Contains(w.nLocationID)).ToList();
lstData.ForEach(f =>
{
var IsUse = lstMaterial.Where(w => w.nLocationID == f.nLocationID).ToList();
if (IsUse.Count() == 0)
{
f.IsDel = true;
}
});
db.SaveChanges();
result.sStatus = SysFunc.process_Success;
}
}
catch (Exception e)
{
result.sStatus = SysFunc.process_Error;
result.sMsg = e.Message;
}
return(result);
}
public SysModalGlobal.CResutlWebMethod SavetoDB([FromBody] TB_Material_Location data)
{
PTTGSP_DWSContext db = new PTTGSP_DWSContext();
var result = new SysModalGlobal.CResutlWebMethod();
try
{
var MaterialLocation = db.TB_Material_Location.ToList();
var duplicate = (from a in db.TB_Material_Location
where !a.IsDel && a.sName.Trim().ToLower() == data.sName.Trim().ToLower() && a.nLocationID != data.nLocationID
select a).FirstOrDefault();
if (duplicate != null)
{
// result.sStatus = SysGlobal.SysFunc.process_Duplicate;
result.sStatus = STFunction.process_Warning();
result.sMsg = "สถานที่เก็บวัสดุนี้มีในระบบอยู่แล้ว";
return(result);
}
var nLocationID = (MaterialLocation.Any() ? MaterialLocation.Max(m => m.nLocationID) : 0) + 1;
if (data.nLocationID == 0)
{
db.TB_Material_Location.Add(new TB_Material_Location
{
sName = data.sName,
sDetail = data.sDetail,
IsActive = data.IsActive,
IsDel = false,
dCreate = DateTime.Now,
sCreateBy = data.sCreateBy,
dUpdate = DateTime.Now,
sUpdateBy = data.sUpdateBy,
});
db.SaveChanges();
}
else
{
var oldnID = (from a in db.TB_Material_Location
where a.nLocationID == data.nLocationID
select a).FirstOrDefault();
if (oldnID != null)
{
oldnID.sName = data.sName;
oldnID.sDetail = data.sDetail;
oldnID.IsActive = data.IsActive;
oldnID.IsDel = false;
oldnID.dUpdate = DateTime.Now;
oldnID.sUpdateBy = data.sUpdateBy;
db.SaveChanges();
}
}
result.sStatus = SysFunc.process_Success;
}
catch (Exception e)
{
result.sStatus = SysFunc.process_Error;
result.sMsg = e.Message;
}
return(result);
}
public SysModalGlobal.CResutlWebMethod SavetoDB([FromBody] lstSavedata data)
{
PTTGSP_DWSContext db = new PTTGSP_DWSContext();
var result = new SysModalGlobal.CResutlWebMethod();
try
{
var Work = db.TB_Work.ToList();
var WorkMaterials = db.TB_Work_Material.ToList();
var duplicate = (from a in db.TB_Work
where !a.IsDel && a.sName.Trim().ToLower() == data.sName.Trim().ToLower() && a.nWorkID != data.nWorkID
select a).FirstOrDefault();
if (duplicate != null)
{
// result.sStatus = SysGlobal.SysFunc.process_Duplicate;
result.sStatus = STFunction.process_Warning();
result.sMsg = "ลักษณะงานนี้มีในระบบอยู่แล้ว";
return(result);
}
var nWorkID = (Work.Any() ? Work.Max(m => m.nWorkID) : 0) + 1;
if (data.nWorkID == 0)
{
TB_Work a = new TB_Work()
{
sName = data.sName,
nReasonID = data.nReasonID,
sDetail = data.sDetail,
IsActive = data.IsActive,
IsDel = false,
dCreate = DateTime.Now,
sCreateBy = data.sCreateBy,
dUpdate = DateTime.Now,
sUpdateBy = data.sUpdateBy,
};
db.TB_Work.Add(a);
db.SaveChanges();
db = new PTTGSP_DWSContext();
foreach (var per in data.lstWorkMaterial)
{
//data.lstWorkMaterial.Remove(per);
if (per.nWorkID == 0)
{
TB_Work_Material s = new TB_Work_Material();
s.nWorkID = nWorkID;
s.nMaterialID = per.nMaterialID;
s.nAmount = per.nAmount;
s.IsActive = per.IsActive;
db.TB_Work_Material.Add(s);
}
else
{
var edit = db.TB_Work_Material.FirstOrDefault(w => w.nWorkID == per.nWorkID);
if (edit != null)
{
edit.nMaterialID = per.nMaterialID;
edit.nAmount = per.nAmount;
edit.IsActive = per.IsActive;
}
}
}
db.SaveChanges();
}
else
{
var oldnID = (from a in db.TB_Work
where a.nWorkID == data.nWorkID
select a).FirstOrDefault();
if (oldnID != null)
{
oldnID.sName = data.sName;
oldnID.nReasonID = data.nReasonID;
oldnID.sDetail = data.sDetail;
oldnID.IsActive = data.IsActive;
oldnID.IsDel = false;
oldnID.dUpdate = DateTime.Now;
oldnID.sUpdateBy = data.sUpdateBy;
db.SaveChanges();
}
foreach (var per in data.lstWorkMaterial)
{
if (nWorkID != 0)
{
var editdata = db.TB_Work_Material.FirstOrDefault(w => w.nWorkID == per.nWorkID);
if (editdata != null)
{
db.TB_Work_Material.Remove(editdata);
editdata.nAmount = per.nAmount;
editdata.IsActive = per.IsActive;
}
}
}
db.SaveChanges();
foreach (var per in data.lstWorkMaterial)
{
TB_Work_Material s = new TB_Work_Material();
s.nMaterialID = per.nMaterialID;
s.nAmount = per.nAmount;
s.IsActive = per.IsActive;
db.TB_Work_Material.Add(s);
}
db.SaveChanges();
}
result.sStatus = SysFunc.process_Success;
}
catch (Exception e)
{
result.sStatus = SysFunc.process_Error;
result.sMsg = e.Message;
}
return(result);
}
