public IActionResult Savedata(V_Material_Category oV_Material_Category) { CResutlWebMethod result = new CResutlWebMethod(); PTTGSP_DWSContext db = new PTTGSP_DWSContext(); result.sStatus = STFunction.process_Success(); try { if (!db.V_Material_Category.Any(w => w.sCategoryName.ToLower().Trim() == oV_Material_Category.sCategoryName.ToLower().Trim() && w.nCategoryID != oV_Material_Category.nCategoryID)) { if (!db.V_Material_Category.Any(w => w.sCategoryCode.ToLower().Trim() == oV_Material_Category.sCategoryCode.ToLower().Trim() && w.nCategoryID != oV_Material_Category.nCategoryID)) { TB_Material_Category otb_material_category = db.TB_Material_Category.Where(w => w.nCategoryID == oV_Material_Category.nCategoryID).FirstOrDefault(); if (otb_material_category == null) { otb_material_category = new TB_Material_Category(); otb_material_category.dCreate = DateTime.Now; db.TB_Material_Category.Add(otb_material_category); } otb_material_category.nGroupID = oV_Material_Category.nGroupID.ToInt(); otb_material_category.sCategoryCode = oV_Material_Category.sCategoryCode; otb_material_category.sName = oV_Material_Category.sCategoryName; otb_material_category.sDetail = oV_Material_Category.sDetail; otb_material_category.nOrder = oV_Material_Category.nOrder; otb_material_category.IsActive = oV_Material_Category.IsActive; otb_material_category.dUpdate = DateTime.Now; db.SaveChanges(); } else { result.sMsg = "รหัสประเภทวัสดุนี้มีในระบบแล้ว"; result.sStatus = STFunction.process_Warning(); } } else { result.sMsg = "ชื่อประเภทวัสดุนี้มีในระบบแล้ว"; result.sStatus = STFunction.process_Warning(); } } catch (Exception e) { result.sStatus = STFunction.process_Failed(); result.sMsg = e.ToString(); } return(Ok(result)); }
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)); }