public bool DeleteData(ArrayList arrData)
{
bool ret = true;
OracleDBObj obj = new OracleDBObj();
obj.CreateConnection();
obj.CreateTransaction();
try
{
PDReturnItemDAL itemDAL = new PDReturnItemDAL();
for (int i = 0; i < arrData.Count; i++)
{
DALObj.GetDataByLOID(Convert.ToDouble(arrData[i]), obj.zTrans);
itemDAL.DeleteDataByPDReturn(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 DataTable GetPDReturnItem(double pdreturn)
{
PDReturnItemDAL itemDAL = new PDReturnItemDAL();
return DALObj.GetPDReturnItemList(pdreturn);
}
private void UpdateData(string userID, ProductReturnData data, System.Data.OracleClient.OracleTransaction trans)
{
bool ret = true;
if (ValidateData(data))
{
DALObj.ACTIVE = data.ACTIVE;
DALObj.STATUS = data.STATUS;
DALObj.SUPPLIER = data.SUPPLIER;
DALObj.CADDRESS = data.CADDRESS;
DALObj.CFAX = data.CFAX;
DALObj.CNAME = data.CNAME;
DALObj.CTEL = data.CTEL;
DALObj.PDRETURNDATE = data.PDRETURNDATE;
DALObj.REASON = data.REASON;
DALObj.REFLOID = data.REFLOID;
DALObj.REFTABLE = data.REFTABLE;
DALObj.REMARK = data.REMARK;
DALObj.TYPE = data.TYPE;
if (DALObj.OnDB)
ret = DALObj.UpdateCurrentData(userID, trans);
else
ret = DALObj.InsertCurrentData(userID, trans);
_LOID = DALObj.LOID;
if (!ret)
{
throw new ApplicationException(DALObj.ErrorMessage);
}
PDReturnItemDAL itemDAL = new PDReturnItemDAL();
itemDAL.DeleteDataByPDReturn(data.LOID, trans);
for (Int16 i = 0; i < data.ITEM.Count; ++i)
{
ProductReturnItemData item = (ProductReturnItemData)data.ITEM[i];
itemDAL.ACTIVE = Constz.ActiveStatus.Active;
itemDAL.PDRETURN = DALObj.LOID;
itemDAL.PRODUCT = item.PRODUCT;
itemDAL.PRICE = item.PRICE;
itemDAL.QTY = item.QTY;
itemDAL.REFLOID = item.LOID;
itemDAL.REFTABLE = "STOCKOUTITEM";
itemDAL.UNIT = item.UNIT;
itemDAL.STATUS = Constz.Requisition.Status.Waiting.Code;
itemDAL.LOTNO = item.LOTNO;
itemDAL.OnDB = false;
ret = itemDAL.InsertCurrentData(userID, trans);
if (!ret) throw new ApplicationException(itemDAL.ErrorMessage);
}
}
else
throw new ApplicationException(_error);
}
