public bool DeleteData(ArrayList arrData) { bool ret = true; OracleDBObj obj = new OracleDBObj(); obj.CreateConnection(); obj.CreateTransaction(); try { PRItemDAL itemDAL = new PRItemDAL(); for (int i = 0; i < arrData.Count; i++) { DALObj.GetDataByLOID(Convert.ToDouble(arrData[i]), obj.zTrans); itemDAL.DeleteDataByPDRequest(Convert.ToDouble(arrData[i]), obj.zTrans); ret = DALObj.DeleteCurrentData(obj.zTrans); if (!ret) throw new ApplicationException(DALObj.ErrorMessage); } obj.zTrans.Commit(); obj.CloseConnection(); } catch (Exception ex) { obj.zTrans.Rollback(); obj.CloseConnection(); ret = false; _error = ex.Message; } return ret; }
public bool UpdateData(string userID, PurchaseRequestData data) { bool ret = true; if (ValidateData(data)) { OracleDBObj obj = new OracleDBObj(); obj.CreateConnection(); obj.CreateTransaction(); try { DALObj.OnDB = false; DALObj.GetDataByLOID(data.LOID, obj.zTrans); DALObj.CODE = data.CODE; DALObj.REQUESTDATE = data.REQUSETDATE; DALObj.ORDERTYPE = data.ORDERTYPE; DALObj.PURCHASETYPE = data.PURCHASETYPE; DALObj.REQUESTBY = data.REQUESTBY; DALObj.DIVISION = data.DIVISION; DALObj.APPROVER = data.APPROVER; if (data.APPROVEDATE.Year != 1) { DALObj.APPROVEDATE = data.APPROVEDATE; } DALObj.APPROVE = data.APPROVE; DALObj.ACTIVE = data.ACTIVE; DALObj.STATUS = data.STATUS; DALObj.REQUIREMENT = data.REQUIREMENT; DALObj.REASON = data.REASON; DALObj.REMARK = data.REMARK; DALObj.FROMCOMPANY = data.FROMCOMPANY; if (DALObj.OnDB) ret = DALObj.UpdateCurrentData(userID, obj.zTrans); else ret = DALObj.InsertCurrentData(userID, obj.zTrans); _LOID = DALObj.LOID; if (!ret) { throw new ApplicationException(DALObj.ErrorMessage); } PRItemDAL itemDAL = new PRItemDAL(); itemDAL.DeleteDataByPDRequest(data.LOID, obj.zTrans); for (Int16 i = 0; i < data.ITEM.Count; ++i) { PRItemData item = (PRItemData)data.ITEM[i]; itemDAL.PRODUCT = item.PRODUCT; itemDAL.PDREQUEST = DALObj.LOID; itemDAL.QTY = item.QTY; itemDAL.UNIT = item.UNIT; itemDAL.MINSTOCK = item.MINSTOCK; itemDAL.MAXSTOCK = item.MAXSTOCK; itemDAL.STOCK = item.STOCK; itemDAL.OLDPRICE = item.OLDPRICE; itemDAL.CURPRICE = item.CURPRICE; itemDAL.MINPRICE = item.MINPRICE; itemDAL.LAST3MON = item.LAST3MON; itemDAL.LASTYEAR = item.LASTYEAR; itemDAL.DUEDATE = item.DUEDATE; itemDAL.ACTIVE = item.ACTIVE; itemDAL.URGENT = item.URGENT; itemDAL.ISMATERIAL = item.ISMATERIAL; itemDAL.OnDB = false; ret = itemDAL.InsertCurrentData(userID, obj.zTrans); if (!ret) throw new ApplicationException(itemDAL.ErrorMessage); } obj.zTrans.Commit(); obj.CloseConnection(); } catch (Exception ex) { obj.zTrans.Rollback(); obj.CloseConnection(); ret = false; _error = ex.Message; } } else ret = false; return ret; }