public ENResult insert(uspWAEntrySearch_Result data, IList <ENEntryDetail> listDetail) { try { using (erpStoreEntities db = new erpStoreEntities()) { ObjectParameter objIdEntry = new ObjectParameter("idEntry", 0); db.uspWAEntryInsert(data.idStore, data.idSupplier, data.entryType, data.date, PUser, objIdEntry, PReturnCode, PReturnMessage); if (Convert.ToInt32(PReturnCode.Value) == 0) { if (listDetail != null) { for (int i = 0; i < listDetail.Count; i++) { ENEntryDetail temp = listDetail[i]; string due = ""; if (temp.dueDate.Year != 1) { due = temp.dueDate.ToString("yyyy-MM-dd"); } // objIdEntryDetail out put * faltaa ObjectParameter objIdEntryDetail = new ObjectParameter("idEntryDetail", 0); db.uspWAEntryDetailInsert(Convert.ToInt32(objIdEntry.Value), temp.idProduct, temp.quantity, temp.purchasePrice, due, PUser, objIdEntryDetail, PReturnCode, PReturnMessage); int codeTemp = Convert.ToInt32(PReturnCode.Value); string messageTemp = Convert.ToString(PReturnMessage.Value); if (listDetail[i].listDetailProperty != null) { for (int j = 0; j < listDetail[i].listDetailProperty.Count; j++) { ENEntryDetailProperty tempProperty = listDetail[i].listDetailProperty[j]; db.uspWAEntryDetailPropertyInsert(Convert.ToInt32(objIdEntry.Value), Convert.ToInt32(objIdEntryDetail.Value), tempProperty.idProduct, tempProperty.idProperty, tempProperty.value, PUser, PReturnCode, PReturnMessage); if (Convert.ToInt32(PReturnCode.Value) != 0) { break; } } } if (Convert.ToInt32(PReturnCode.Value) != 0) { break; } } return(new ENResult(Convert.ToInt32(PReturnCode.Value), Convert.ToString(PReturnMessage.Value))); } 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(uspWAEntrySearch_Result data) { try { using (erpStoreEntities db = new erpStoreEntities()) { db.uspWAEntryDelete(data.idEntry, PUser, PReturnCode, PReturnMessage); return(new ENResult(Convert.ToInt32(PReturnCode.Value), Convert.ToString(PReturnMessage.Value))); } } catch (Exception ex) { return(PUnexpectedError(ex)); } }