private bool NewRequisition(string UserID, ToDoListMinimumStockRequestData data)
{
bool ret = true;
OracleDBObj obj = new OracleDBObj();
obj.CreateConnection();
obj.CreateTransaction();
try
{
RequisitionDAL _DAL = new RequisitionDAL();
_DAL.OnDB = false;
_DAL.OFFICER = data.REQUESTBY;
_DAL.REQDATE = DateTime.Now.Date;
_DAL.ACTIVE = data.ACTIVE;
_DAL.STATUS = data.STATUS;
_DAL.WAREHOUSE = data.WAREHOUSE;
_DAL.REQUISITIONTYPE = data.REQUISITIONTYPE;
_DAL.RESERVEDATE = DateTime.Now.Date;
ret = _DAL.InsertCurrentData(UserID, obj.zTrans);
if (!ret)
{
throw new ApplicationException(_DAL.ErrorMessage);
}
RequisitionItemDAL _DALItem = new RequisitionItemDAL();
for (int i = 0; i < data.ITEM.Count; ++i)
{
_DALItem.OnDB = false;
ToDoListMinimumStockRequestItemData itemData = (ToDoListMinimumStockRequestItemData)data.ITEM[i];
_DALItem.ACTIVE = data.ACTIVE;
_DALItem.PRODUCT = itemData.PRODUCT;
_DALItem.QTY = itemData.QTY;
_DALItem.REQUISITION = _DAL.LOID;
_DALItem.UNIT = itemData.UNIT;
_DALItem.DUEDATE = DateTime.Now.Date;
ret = _DALItem.InsertCurrentData(UserID, obj.zTrans);
if (!ret)
{
throw new ApplicationException(_DALItem.ErrorMessage);
}
}
_LOID = _DAL.LOID;
obj.zTrans.Commit();
obj.CloseConnection();
}
catch (Exception ex)
{
obj.zTrans.Rollback();
obj.CloseConnection();
ret = false;
_error = ex.Message;
}
return ret;
}
public double InsertRequisition(string UserId, RequisitionData data)
{
Boolean ret = true;
RequisitionDAL oDAL = new RequisitionDAL();
oDAL.REQDATE = Convert.ToDateTime(data.REQDATE);
oDAL.REQUISITIONTYPE = Convert.ToDouble(data.REQUISITIONTYPE);
oDAL.STATUS = data.STATUS.ToString();
oDAL.WAREHOUSE = Convert.ToDouble(data.WAREHOUSE);
oDAL.RESERVEDATE = Convert.ToDateTime(data.RESERVEDATE);
oDAL.ACTIVE = data.ACTIVE.ToString();
ret = oDAL.InsertCurrentData(UserId, null);
if (ret == false)
{
_error = oDAL.ErrorMessage;
return 0;
}
else
return oDAL.LOID;
}
