public ENResult update(uspGEProductSearch_Result data, IList <ENProductProperty> listProperty, IList <ENProductProperty> listPropertyDelete) { try { using (erpStoreEntities db = new erpStoreEntities()) { db.uspGEProductUpdate(data.idProduct, data.idCategory, data.idBrand, data.codeUnit, data.name, data.divisible, data.divisibleCodeUnit, data.divisibleNumberParts, data.perishable, data.traceable, data.barcodeType, PUser, PReturnCode, PReturnMessage); if (Convert.ToInt32(PReturnCode.Value) == 0) { if (listProperty != null) { for (int i = 0; i < listProperty.Count; i++) { ENProductProperty temp = listProperty[i]; if (temp.idProperty == 0) { db.uspGEProductPropertyInsert(data.idProduct, temp.name, temp.abbreviation, temp.required, PUser, PReturnCode, PReturnMessage); } else { db.uspGEProductPropertyUpdate(temp.idProperty, data.idProduct, temp.name, temp.abbreviation, temp.required, PUser, PReturnCode, PReturnMessage); } if (Convert.ToInt32(PReturnCode.Value) != 0) { break; } } } if (listPropertyDelete != null) { for (int i = 0; i < listPropertyDelete.Count; i++) { ENProductProperty temp = listPropertyDelete[i]; db.uspGEProductPropertyDelete(data.idProduct, temp.idProperty, PUser, PReturnCode, PReturnMessage); if (Convert.ToInt32(PReturnCode.Value) != 0) { break; } } } return(new ENResult(Convert.ToInt32(PReturnCode.Value), Convert.ToString(PReturnMessage.Value))); } else { return(new ENResult(Convert.ToInt32(PReturnCode.Value), Convert.ToString(PReturnMessage.Value))); } } } catch (Exception ex) { return(PUnexpectedError(ex)); } }
public ENResult delete(uspGEProductPropertySearch_Result data) { try { using (erpStoreEntities db = new erpStoreEntities()) { db.uspGEProductPropertyDelete(data.idProduct, data.idProperty, PUser, PReturnCode, PReturnMessage); return(new ENResult(Convert.ToInt32(PReturnCode.Value), Convert.ToString(PReturnMessage.Value))); } } catch (Exception ex) { return(PUnexpectedError(ex)); } }