public objTransaction Select(int transID)
{
IDataReader idr = null;
objTransaction o = new objTransaction();
try
{
idr = db.Select(transID);
o = Select_Obj(idr);
}
catch (Exception)
{
throw;
}
finally
{
if (idr != null)
{
idr.Dispose();
}
}
return(o);
}
private List <objTransaction> Select_ObjLi(IDataReader idr)
{
List <objTransaction> liO = new List <objTransaction>();
bool rtNull = true;
if (idr != null)
{
while (idr.Read())
{
rtNull = false;
objTransaction o = new objTransaction();
if (idr["transID"] != DBNull.Value)
{
o.transID = Convert.ToInt32(idr["transID"]);
}
if (idr["transSystemIndex"] != DBNull.Value)
{
o.transSystemIndex = Convert.ToInt32(idr["transSystemIndex"]);
}
if (idr["transParticipantID"] != DBNull.Value)
{
o.transParticipantID = Convert.ToInt32(idr["transParticipantID"]);
}
if (idr["transRefID"] != DBNull.Value)
{
o.transRefID = Convert.ToString(idr["transRefID"]);
}
if (idr["transAttachedFiles"] != DBNull.Value)
{
o.transAttachedFiles = Convert.ToString(idr["transAttachedFiles"]);
}
if (idr["transInvoiceID"] != DBNull.Value)
{
o.transInvoiceID = Convert.ToInt32(idr["transInvoiceID"]);
}
if (idr["transDrAccount"] != DBNull.Value)
{
o.transDrAccount = Convert.ToInt32(idr["transDrAccount"]);
}
if (idr["transCrAccount"] != DBNull.Value)
{
o.transCrAccount = Convert.ToInt32(idr["transCrAccount"]);
}
if (idr["transNarration"] != DBNull.Value)
{
o.transNarration = Convert.ToString(idr["transNarration"]);
}
if (idr["transAmount"] != DBNull.Value)
{
o.transAmount = Convert.ToDecimal(idr["transAmount"]);
}
if (idr["transCreatedOn"] != DBNull.Value)
{
o.transCreatedOn = Convert.ToDateTime(idr["transCreatedOn"]);
}
if (idr["transCreatedBy"] != DBNull.Value)
{
o.transCreatedBy = Convert.ToInt32(idr["transCreatedBy"]);
}
if (idr["transUpdatedOn"] != DBNull.Value)
{
o.transUpdatedOn = Convert.ToDateTime(idr["transUpdatedOn"]);
}
if (idr["transUpdatedBy"] != DBNull.Value)
{
o.transUpdatedBy = Convert.ToInt32(idr["transUpdatedBy"]);
}
if (idr["transStatus"] != DBNull.Value)
{
o.transStatus = Convert.ToInt32(idr["transStatus"]);
}
if (idr["transSystemRestrict"] != DBNull.Value)
{
o.transSystemRestrict = Convert.ToBoolean(idr["transSystemRestrict"]);
}
if (idr["transGroupID"] != DBNull.Value)
{
o.transGroupID = Convert.ToInt32(idr["transGroupID"]);
}
if (idr["transIsCompound"] != DBNull.Value)
{
o.transIsCompound = Convert.ToBoolean(idr["transIsCompound"]);
}
if (idr["transType"] != DBNull.Value)
{
o.transType = Convert.ToInt32(idr["transType"]);
}
if (idr["deptId"] != DBNull.Value)
{
o.deptId = Convert.ToInt32(idr["deptId"]);
}
liO.Add(o);
}
}
if (rtNull == true)
{
liO = null;
}
return(liO);
}
public void Update(objTransaction i)
{
db.Update(
i.transID, i.transSystemIndex, i.transParticipantID, i.transRefID, i.transAttachedFiles, i.transInvoiceID, i.transDrAccount, i.transCrAccount, i.transNarration, i.transAmount, i.transCreatedOn, i.transCreatedBy, i.transUpdatedOn, i.transUpdatedBy, i.transStatus, i.transSystemRestrict, i.transGroupID, i.transIsCompound, i.transType, i.deptId);
}
