public int SaveRows(DbTransaction pTran, RequestDetailList RequestDetailList, bool CreateTransaction)
{
int intRows = 0;
DbTransaction objTran = pTran;
Exception exception = null;
try
{
if (pTran == null && CreateTransaction == true)
{
objTran = RequestDetailData.CreateTransaction();
}
intRows = RequestDetailData.SaveRows(objTran, RequestDetailList);
if (pTran == null && objTran != null && CreateTransaction == true)
{
RequestDetailData.CommitTransaction(objTran, true);
objTran = null;
}
}
catch (Exception EX)
{
exception = EX;
if (pTran == null && objTran != null && CreateTransaction == true)
{
RequestDetailData.RollbackTransaction(objTran, true);
objTran = null;
}
}
finally
{
}
return(intRows);
}
private List <RequestDetail> fillRequestDetailList()
{
RequestDetailBusiness _RequestDetailBusiness = new RequestDetailBusiness();
RequestDetailList _RequestDetailList = _RequestDetailBusiness.SelectRows(null, null, null, null);
return(_RequestDetailList);
}
public RequestDetailList SelectRows(DbTransaction pTran, System.Int32?Id, System.Int32?cardTypeID, System.Int32?requestID)
{
RequestDetailList RequestDetailList = new RequestDetailList();
Exception exception = null;
DbParameter[] Parameters = new DbParameter[3];
Parameters[0] = _getIdParameter(Id, ParameterDirection.Input);
Parameters[1] = _getcardTypeIDParameter(cardTypeID, ParameterDirection.Input);
Parameters[2] = _getrequestIDParameter(requestID, ParameterDirection.Input);
DbDataReader Dr = ExecuteReader(pTran, "[Transactions].[SelectRequestDetail]", Parameters);
try
{
if (Dr != null)
{
while (Dr.Read())
{
RequestDetail RequestDetail = new RequestDetail();
if (Dr["Id"] != DBNull.Value)
{
RequestDetail.Id = (System.Int32)Dr["Id"];
}
if (Dr["quantity"] != DBNull.Value)
{
RequestDetail.quantity = (System.Int32?)Dr["quantity"];
}
if (Dr["cardTypeID"] != DBNull.Value)
{
RequestDetail.cardTypeID = (System.Int32?)Dr["cardTypeID"];
}
if (Dr["requestID"] != DBNull.Value)
{
RequestDetail.requestID = (System.Int32?)Dr["requestID"];
}
RequestDetailList.FillRow(RequestDetail);
RequestDetail = null;
}
}
}
catch (Exception Ex)
{
exception = Ex;
}
finally
{
if (Dr != null)
{
if (Dr.IsClosed == false)
{
Dr.Close();
}
Dr = null;
}
}
return(RequestDetailList);
}
private List <RequestDetail> fillRequestDetailListbyRequestStatus(List <Request> requestList)
{
List <RequestDetail> requestDetailsList = new List <RequestDetail>();
RequestDetailBusiness _RequestDetailBusiness = default(RequestDetailBusiness);
RequestDetailList _RequestDetailList = default(RequestDetailList);
foreach (Request request in requestList)
{
_RequestDetailBusiness = new RequestDetailBusiness();
_RequestDetailList = _RequestDetailBusiness.SelectRows(null, null, request.Id);
if (_RequestDetailList != null && _RequestDetailList.Count > 0)
{
foreach (RequestDetail requestDetail in _RequestDetailList)
{
requestDetailsList.Add(Copier.copyRequestDetail(requestDetail));
}
}
}
return(requestDetailsList);
}
public int SaveRows(DbTransaction pTran, RequestDetailList RequestDetailList)
{
int intRows = 0;
for (int i = 0; i < RequestDetailList.Count; i++)
{
switch (RequestDetailList[i].CommonState)
{
case CommonState.Added:
intRows += InsertRow(pTran, RequestDetailList[i]);
break;
case CommonState.Modified:
intRows += UpdateRow(pTran, RequestDetailList[i]);
break;
case CommonState.Deleted:
intRows += DeleteRow(pTran, RequestDetailList[i]);
break;
}
}
return(intRows);
}
public int SaveRows(DbTransaction pTran, RequestDetailList RequestDetailList)
{
return(SaveRows(pTran, RequestDetailList, true));
}
public int SaveRows(RequestDetailList RequestDetailList)
{
DbTransaction Tran = null;
return(SaveRows(Tran, RequestDetailList, true));
}
public RequestDTO UpdateRequestinDB(RequestDTO requestDTO)
{
BaseDataAccess _db = new BaseDataAccess();
using (DbTransaction dbTransaction = _db.CreateTransaction())
{
try
{
// 1- Perform Mapping to Input (for Saving in DB)
if (Mapper.MapRequestAsInput(requestDTO))
{
// 2- Select Request to be updated
RequestBusiness requestBusiness = new RequestBusiness();
RequestList requestList = requestBusiness.SelectRows(Mapper._Request.Id, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null);
if (requestList != null && requestList.Count > 0)
{
requestList[0].requestNumber = Mapper._Request.requestNumber;
requestList[0].totalQuantity = Mapper._Request.totalQuantity;
requestList[0].PDD = Mapper._Request.PDD;
requestList[0].customerID = Mapper._Request.customerID;
requestList[0].creationDate = Mapper._Request.creationDate;
requestList[0].creationUserID = Mapper._Request.creationUserID;
requestList[0].approvalDate = Mapper._Request.approvalDate;
requestList[0].approvalUserID = Mapper._Request.approvalUserID;
requestList[0].receiveDate = Mapper._Request.receiveDate;
requestList[0].receiveUserID = Mapper._Request.receiveUserID;
requestList[0].rejectionDate = Mapper._Request.rejectionDate;
requestList[0].rejectionUserID = Mapper._Request.rejectionUserID;
requestList[0].rejectionReasonID = Mapper._Request.rejectionReasonID;
requestList[0].requestTypeID = Mapper._Request.requestTypeID;
requestList[0].requestStatusID = Mapper._Request.requestStatusID;
requestList[0].requestCalssID = Mapper._Request.requestCalssID;
requestList[0].requestPriorityID = Mapper._Request.requestPriorityID;
// 3- Update Request Data by Input Values
requestBusiness = new RequestBusiness();
if (requestBusiness.UpdateRow(dbTransaction, requestList[0]) > 0)
{
// 4- Remove Request Details Already Saved for that Request in DB
RequestDetailBusiness requestDetailBusiness = new RequestDetailBusiness();
RequestDetailList requestDetailList = requestDetailBusiness.SelectRows(null, null, Mapper._Request.Id);
if (requestDetailList != null && requestDetailList.Count > 0)
{
foreach (RequestDetail requestDetail in requestDetailList)
{
requestDetailBusiness = new RequestDetailBusiness();
requestDetailBusiness.DeleteRow(dbTransaction, requestDetail);
}
}
// 5- Add New Request Details from Input
if (Mapper._RequestDetailListInput != null && Mapper._RequestDetailListInput.Count > 0)
{
foreach (RequestDetail requestDetail in Mapper._RequestDetailListInput)
{
requestDetailBusiness = new RequestDetailBusiness();
requestDetailBusiness.InsertRow(dbTransaction, requestDetail);
}
dbTransaction.Commit();
}
}
else
{
dbTransaction.Rollback();
throw new Exception("DataBase Operation Failure");
}
}
else
{
throw new Exception("Request Id Not Found in DB");
}
}
else
{
throw new ArgumentNullException("requestDTO");
}
}
catch (Exception ex)
{
dbTransaction.Rollback();
throw new Exception("DataBase Operation Failure");
}
}
return(requestDTO);
}
