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)); }