public bool RequisitionApprove(string userID, ArrayList arr)
{
bool ret = true;
OracleConnection conn = OracleDB.GetConnection();
OracleTransaction zTran = conn.BeginTransaction(IsolationLevel.ReadCommitted);
try
{
foreach (string loid in arr)
{
string sqlRequisition = "UPDATE REQUISITION SET STATUS = '" + Constz.Requisition.Status.Approved.Code + "' ";
sqlRequisition += " WHERE LOID = " + loid;
OracleDB.ExecNonQueryCmd(sqlRequisition, zTran);
RequisitionDAL rDAL = new RequisitionDAL();
bool rr = rDAL.CutStockRequisition(Convert.ToDouble(loid), userID, zTran);
}
ret = true;
zTran.Commit();
}
catch (Exception ex)
{
ret = false;
zTran.Rollback();
_error = ex.Message;
return false;
}
conn.Close();
return ret;
}
public static bool DeleteRequisition(RequisitionData data)
{
Boolean ret = true;
RequisitionDAL oDAL = new RequisitionDAL();
oDAL.GetDataByLOID(data.LOID, null);
ret = oDAL.DeleteCurrentData(null);
return ret;
}
public bool UpdateRequsitionData(string UserID, RequisitionData data)
{
bool ret = true;
RequisitionDAL oDAL = new RequisitionDAL();
oDAL.GetDataByLOID(data.LOID,null);
oDAL.CUSTOMER = Convert.ToDouble(data.CUSTOMER);
oDAL.TOTAL = Convert.ToDouble(data.TOTAL);
oDAL.REASON = data.REASON.ToString();
oDAL.REMARK = data.REMARK.ToString();
ret = oDAL.UpdateCurrentData(UserID, null);
if (ret == false)
{
_error = oDAL.ErrorMessage;
return ret;
}
else
return ret;
}
