public ResultAPI SaveData(GetSeller_Edit data)
{
db = new PTTGSP_DWSContext();
ResultAPI result = new ResultAPI();
if (data.nVendorID == 0) //create
{
var CheckCode = db.TB_Vendor.FirstOrDefault(w => w.sCompanyCode == data.sCompanyCode && w.IsDel); //Check CompanyCode
if (CheckCode != null)
{
result.Message = "มีรหัสบริษัทในระบบแล้ว !";
result.Status = ResultStatus.Warning;
}
else
{
TB_Vendor s = new TB_Vendor();
s.sCompanyCode = data.sCompanyCode;
s.sCompanyName = data.sCompanyName;
s.sContactName = data.sContactName;
s.sEmail = data.sEmail;
s.sTel = data.sTel;
s.sDetail = data.sDetail;
s.IsActive = data.IsActive == "0" ? true : false;
s.sCreateBy = "";
s.sUpdateBy = "";
s.dCreate = DateTime.Now;
s.dUpdate = DateTime.Now;
db.TB_Vendor.Add(s);
result.Status = ResultStatus.Success;
}
}
else //Update
{
var CheckCode = db.TB_Vendor.FirstOrDefault(w => w.sCompanyCode == data.sCompanyCode && w.IsDel); //Check CompanyCode
if (CheckCode != null)
{
result.Message = "มีรหัสบริษัทในระบบแล้ว !";
result.Status = ResultStatus.Warning;
}
else
{
int nID = data.nVendorID;
var Update = db.TB_Vendor.FirstOrDefault(w => w.nVendorID == nID);
if (Update != null)
{
Update.sCompanyCode = data.sCompanyCode;
Update.sCompanyName = data.sCompanyName;
Update.sContactName = data.sContactName;
Update.sEmail = data.sEmail;
Update.sTel = data.sTel;
Update.sDetail = data.sDetail;
Update.IsActive = data.IsActive == "0" ? true : false;
Update.sUpdateBy = "";
Update.dUpdate = DateTime.Now;
result.Status = ResultStatus.Success;
}
else
{
result.Message = "ข้อมูลไม่ถูกต้อง !";
result.Status = ResultStatus.Error;
}
}
}
db.SaveChanges();
return(result);
}
public IActionResult GetData_Edit(int nID)
{
TB_Vendor lst = db.TB_Vendor.FirstOrDefault(w => w.nVendorID == nID);
return(Ok(lst));
}
