public CResutlWebMethod SetOrder(int nGroupID, string sOrder)
{
CResutlWebMethod result = new CResutlWebMethod();
PTTGSP_DWSContext db = new PTTGSP_DWSContext();
result.sStatus = STFunction.process_Success();
List <TB_Material_Group> listtb_material_group = db.TB_Material_Group.ToList();
TB_Material_Group otb_material_group = listtb_material_group.FirstOrDefault(w => w.nGroupID == nGroupID);
if (otb_material_group != null)
{
otb_material_group.nOrder = sOrder.ToInt();
int n = 0;
var lstItem_OTHER = listtb_material_group.Where(w => w.nGroupID != nGroupID && w.IsDel == false).OrderBy(o => o.nOrder).ToList();
lstItem_OTHER.ForEach(i =>
{
n += 1;
if (n == sOrder.ToInt())
{
n += 1;
}
i.nOrder = n;
});
db.SaveChanges();
}
else
{
result.sMsg = "ไม่พบข้อมูลไม่ถูกต้อง";
result.sStatus = STFunction.process_Warning();
}
return(result);
}
public IActionResult ParcelGroup_Edit(string sGroupID)
{
int nGroupID = sGroupID.ToInt();
TB_Material_Group tb_material_group = new TB_Material_Group();
PTTGSP_DWSContext db = new PTTGSP_DWSContext();
tb_material_group = db.TB_Material_Group.Where(w => w.nGroupID == nGroupID && w.IsDel == false).FirstOrDefault();
if (tb_material_group == null)
{
tb_material_group = new TB_Material_Group();
tb_material_group.IsActive = true;
}
return(Ok(tb_material_group));
}
public IActionResult Savedata(TB_Material_Group TB_Material_Group)
{
CResutlWebMethod result = new CResutlWebMethod();
PTTGSP_DWSContext db = new PTTGSP_DWSContext();
result.sStatus = STFunction.process_Success();
try
{
if (!db.TB_Material_Group.Any(w => w.sName.ToLower().Trim() == TB_Material_Group.sName.ToLower().Trim() && w.nGroupID != TB_Material_Group.nGroupID && w.IsDel != true))
{
TB_Material_Group tb_material_group = db.TB_Material_Group.Where(w => w.nGroupID == TB_Material_Group.nGroupID).FirstOrDefault();
if (tb_material_group == null)
{
tb_material_group = new TB_Material_Group();
tb_material_group.dCreate = DateTime.Now;
db.TB_Material_Group.Add(tb_material_group);
}
tb_material_group.sName = TB_Material_Group.sName;
tb_material_group.sDetail = TB_Material_Group.sDetail;
tb_material_group.nOrder = TB_Material_Group.nOrder;
tb_material_group.IsActive = TB_Material_Group.IsActive;
tb_material_group.dUpdate = DateTime.Now;
db.SaveChanges();
}
else
{
result.sMsg = "ชื่อกลุ่มวัสดุนี้มีในระบบแล้ว";
result.sStatus = STFunction.process_Warning();
}
}
catch (Exception e)
{
result.sStatus = STFunction.process_Failed();
result.sMsg = e.ToString();
}
return(Ok(result));
}
