public int SaveRows(DbTransaction pTran, RequestSearchList RequestSearchList, bool CreateTransaction)
{
int intRows = 0;
DbTransaction objTran = pTran;
Exception exception = null;
try
{
if (pTran == null && CreateTransaction == true)
{
objTran = RequestSearchData.CreateTransaction();
}
intRows = RequestSearchData.SaveRows(objTran, RequestSearchList);
if (pTran == null && objTran != null && CreateTransaction == true)
{
RequestSearchData.CommitTransaction(objTran, true);
objTran = null;
}
}
catch (Exception EX)
{
exception = EX;
if (pTran == null && objTran != null && CreateTransaction == true)
{
RequestSearchData.RollbackTransaction(objTran, true);
objTran = null;
}
}
finally
{
}
return(intRows);
}
public int SaveRows(DbTransaction pTran, RequestSearchList RequestSearchList)
{
int intRows = 0;
for (int i = 0; i < RequestSearchList.Count; i++)
{
switch (RequestSearchList[i].CommonState)
{
case CommonState.Added:
intRows += InsertRow(pTran, RequestSearchList[i]);
break;
case CommonState.Modified:
intRows += UpdateRow(pTran, RequestSearchList[i]);
break;
case CommonState.Deleted:
intRows += DeleteRow(pTran, RequestSearchList[i]);
break;
}
}
return(intRows);
}
public RequestSearchList SelectRows(DbTransaction pTran, System.Int32?Id, System.String requestNumber, System.DateTime?creationDateFrom, System.DateTime?creationDateTo, System.DateTime?approvalDateFrom, System.DateTime?approvalDateTo, System.DateTime?receiveDateFrom, System.DateTime?receiveDateTo, System.DateTime?rejectionDateFrom, System.DateTime?rejectionDateTo)
{
RequestSearchList RequestSearchList = new RequestSearchList();
Exception exception = null;
DbParameter[] Parameters = new DbParameter[10];
Parameters[0] = _getIdParameter(Id, ParameterDirection.Input);
Parameters[1] = _getrequestNumberParameter(requestNumber, ParameterDirection.Input);
Parameters[2] = _getcreationDateFromParameter(creationDateFrom, ParameterDirection.Input);
Parameters[3] = _getcreationDateToParameter(creationDateTo, ParameterDirection.Input);
Parameters[4] = _getapprovalDateFromParameter(approvalDateFrom, ParameterDirection.Input);
Parameters[5] = _getapprovalDateToParameter(approvalDateTo, ParameterDirection.Input);
Parameters[6] = _getreceiveDateFromParameter(receiveDateFrom, ParameterDirection.Input);
Parameters[7] = _getreceiveDateToParameter(receiveDateTo, ParameterDirection.Input);
Parameters[8] = _getrejectionDateFromParameter(rejectionDateFrom, ParameterDirection.Input);
Parameters[9] = _getrejectionDateToParameter(rejectionDateTo, ParameterDirection.Input);
DbDataReader Dr = ExecuteReader(pTran, "[Transactions].[SelectRequestSearch]", Parameters);
try
{
if (Dr != null)
{
while (Dr.Read())
{
RequestSearch RequestSearch = new RequestSearch();
if (Dr["Id"] != DBNull.Value)
{
RequestSearch.Id = (System.Int32)Dr["Id"];
}
if (Dr["requestNumber"] != DBNull.Value)
{
RequestSearch.requestNumber = (System.String)Dr["requestNumber"];
}
if (Dr["totalQuantity"] != DBNull.Value)
{
RequestSearch.totalQuantity = (System.Int32?)Dr["totalQuantity"];
}
if (Dr["PDDFrom"] != DBNull.Value)
{
RequestSearch.PDDFrom = (System.DateTime?)Dr["PDDFrom"];
}
if (Dr["PDDTo"] != DBNull.Value)
{
RequestSearch.PDDTo = (System.DateTime?)Dr["PDDTo"];
}
if (Dr["customerID"] != DBNull.Value)
{
RequestSearch.customerID = (System.Int32?)Dr["customerID"];
}
if (Dr["creationDateFrom"] != DBNull.Value)
{
RequestSearch.creationDateFrom = (System.DateTime?)Dr["creationDateFrom"];
}
if (Dr["creationDateTo"] != DBNull.Value)
{
RequestSearch.creationDateTo = (System.DateTime?)Dr["creationDateTo"];
}
if (Dr["creationUserID"] != DBNull.Value)
{
RequestSearch.creationUserID = (System.Int32?)Dr["creationUserID"];
}
if (Dr["approvalDateFrom"] != DBNull.Value)
{
RequestSearch.approvalDateFrom = (System.DateTime?)Dr["approvalDateFrom"];
}
if (Dr["approvalDateTo"] != DBNull.Value)
{
RequestSearch.approvalDateTo = (System.DateTime?)Dr["approvalDateTo"];
}
if (Dr["approvalUserID"] != DBNull.Value)
{
RequestSearch.approvalUserID = (System.Int32?)Dr["approvalUserID"];
}
if (Dr["receiveDateFrom"] != DBNull.Value)
{
RequestSearch.receiveDateFrom = (System.DateTime?)Dr["receiveDateFrom"];
}
if (Dr["receiveDateTo"] != DBNull.Value)
{
RequestSearch.receiveDateTo = (System.DateTime?)Dr["receiveDateTo"];
}
if (Dr["receiveUserID"] != DBNull.Value)
{
RequestSearch.receiveUserID = (System.Int32?)Dr["receiveUserID"];
}
if (Dr["rejectionDateFrom"] != DBNull.Value)
{
RequestSearch.rejectionDateFrom = (System.DateTime?)Dr["rejectionDateFrom"];
}
if (Dr["rejectionDateTo"] != DBNull.Value)
{
RequestSearch.rejectionDateTo = (System.DateTime?)Dr["rejectionDateTo"];
}
if (Dr["rejectionUserID"] != DBNull.Value)
{
RequestSearch.rejectionUserID = (System.Int32?)Dr["rejectionUserID"];
}
if (Dr["rejectionReasonID"] != DBNull.Value)
{
RequestSearch.rejectionReasonID = (System.Int32?)Dr["rejectionReasonID"];
}
if (Dr["requestTypeID"] != DBNull.Value)
{
RequestSearch.requestTypeID = (System.Int32?)Dr["requestTypeID"];
}
if (Dr["requestStatusID"] != DBNull.Value)
{
RequestSearch.requestStatusID = (System.Int32?)Dr["requestStatusID"];
}
if (Dr["requestCalssID"] != DBNull.Value)
{
RequestSearch.requestCalssID = (System.Int32?)Dr["requestCalssID"];
}
if (Dr["requestPriorityID"] != DBNull.Value)
{
RequestSearch.requestPriorityID = (System.Int32?)Dr["requestPriorityID"];
}
if (Dr["cardTypeID"] != DBNull.Value)
{
RequestSearch.cardTypeID = (System.Int32?)Dr["cardTypeID"];
}
RequestSearchList.FillRow(RequestSearch);
RequestSearch = null;
}
}
}
catch (Exception Ex)
{
exception = Ex;
}
finally
{
if (Dr != null)
{
if (Dr.IsClosed == false)
{
Dr.Close();
}
Dr = null;
}
}
return(RequestSearchList);
}
public int SaveRows(RequestSearchList RequestSearchList)
{
DbTransaction Tran = null;
return(SaveRows(Tran, RequestSearchList));
}
public int SaveRows(DbTransaction pTran, RequestSearchList RequestSearchList)
{
return(SaveRows(pTran, RequestSearchList, true));
}
