public JsonResult InsertEmpCus(string ID, string CUS_ID, string NAME = "")
{
CUSTOMER cus = new CUSTOMER();
var result = cus.Update(CUS_ID, ID);
return(Json(result));
}
public JsonResult DeleteCustomer(string ID, List <string> CUS_ID)
{
var result = 0;
CUSTOMER cus = new CUSTOMER();
foreach (var item in CUS_ID)
{
result = cus.Update(item, "");
}
return(Json(result));
}
public JsonResult InsertUpdateCustomer(CUSTOMER CUS, List <CONTACT> CONTACTS, int ACTION)
{
CUSTOMER cus = new CUSTOMER();
CONTACT con = new CONTACT();
var result = 0;
if (ACTION == 1)
{
result = cus.Update(CUS.ID, CUS.NAME, CUS.ADDRESS, CUS.LOCATION, CUS.TEL, CUS.FAX, CUS.ESTABLE, CUS.CONTACT,
CUS.CLASS, CUS.APPLICATION, CUS.PERSON, CUS.SPEC, CUS.TYPE);
if (CONTACTS != null)
{
foreach (var contact in CONTACTS)
{
if (string.IsNullOrWhiteSpace(contact.ID))
{
con.Insert(CUS.ID, contact.NAME, contact.DOB, contact.POSITION, contact.MOBILE, contact.EMAIL, contact.SEX);
}
else
{
con.Update(contact.ID, contact.NAME, contact.DOB, contact.POSITION, contact.MOBILE, contact.EMAIL, contact.SEX);
}
}
}
}
else
{
CUSTOMER checkExist = cus.Select(CUS.ID).FirstOrDefault();
if (checkExist != null)
{
return(Json(-1));
}
result = cus.Insert(CUS.ID, CUS.NAME, CUS.ADDRESS, CUS.LOCATION, CUS.TEL, CUS.FAX, CUS.ESTABLE, CUS.CONTACT,
CUS.CLASS, CUS.APPLICATION, CUS.PERSON, CUS.SPEC, CUS.TYPE);
if (CONTACTS != null)
{
foreach (var contact in CONTACTS)
{
con.Insert(CUS.ID, contact.NAME, contact.DOB, contact.POSITION, contact.MOBILE, contact.EMAIL, contact.SEX);
}
}
}
return(Json(result));
}