private objChequePrinting Select_Obj(IDataReader idr)
{
objChequePrinting o = new objChequePrinting();
bool rtNull = true;
if (idr != null)
{
while (idr.Read())
{
rtNull = false;
if (idr["chequeId"] != DBNull.Value)
{
o.chequeId = Convert.ToInt32(idr["chequeId"]);
}
if (idr["bankId"] != DBNull.Value)
{
o.bankId = Convert.ToInt32(idr["bankId"]);
}
if (idr["chequeTitle"] != DBNull.Value)
{
o.chequeTitle = Convert.ToString(idr["chequeTitle"]);
}
if (idr["chequeAmount"] != DBNull.Value)
{
o.chequeAmount = Convert.ToString(idr["chequeAmount"]);
}
if (idr["chequeAmountFig"] != DBNull.Value)
{
o.chequeAmountFig = Convert.ToDecimal(idr["chequeAmountFig"]);
}
if (idr["chequeDate"] != DBNull.Value)
{
o.chequeDate = Convert.ToDateTime(idr["chequeDate"]);
}
if (idr["chequeNo"] != DBNull.Value)
{
o.chequeNo = Convert.ToString(idr["chequeNo"]);
}
if (idr["chequeReceivedBy"] != DBNull.Value)
{
o.chequeReceivedBy = Convert.ToString(idr["chequeReceivedBy"]);
}
if (idr["chequeReceiverPhone"] != DBNull.Value)
{
o.chequeReceiverPhone = Convert.ToString(idr["chequeReceiverPhone"]);
}
if (idr["chequeReceiverIDCard"] != DBNull.Value)
{
o.chequeReceiverIDCard = Convert.ToString(idr["chequeReceiverIDCard"]);
}
if (idr["chequeCreatedBy"] != DBNull.Value)
{
o.chequeCreatedBy = Convert.ToInt32(idr["chequeCreatedBy"]);
}
if (idr["chequeCreatedOn"] != DBNull.Value)
{
o.chequeCreatedOn = Convert.ToDateTime(idr["chequeCreatedOn"]);
}
if (idr["chequeStatus"] != DBNull.Value)
{
o.chequeStatus = Convert.ToInt32(idr["chequeStatus"]);
}
}
}
if (rtNull)
{
o = null;
}
return(o);
}
public void Update(objChequePrinting i)
{
db.Update(i.chequeId, i.bankId, i.chequeTitle, i.chequeAmount, i.chequeAmountFig, i.chequeDate, i.chequeNo, i.chequeReceivedBy, i.chequeReceiverPhone, i.chequeReceiverIDCard, i.chequeCreatedBy, i.chequeCreatedOn, i.chequeStatus);
}
public int Add(objChequePrinting i)
{
return(db.Add(i.chequeId, i.bankId, i.chequeTitle, i.chequeAmount, i.chequeAmountFig, i.chequeDate, i.chequeNo, i.chequeReceivedBy, i.chequeReceiverPhone, i.chequeReceiverIDCard, i.chequeCreatedBy, i.chequeCreatedOn, i.chequeStatus));
}
