public static PaymentTran GetItemByRefNbr(String RefNbr)
{
PaymentTran item = new PaymentTran();
var sqlParams = new SqlParameter[1];
sqlParams[0] = new SqlParameter("@RefNbr", RefNbr);
using (var reader = SqlHelper.ExecuteReader("tblUserTran_GetByRefNbr", sqlParams))
{
while (reader.Read())
{
item = GetItemFromReader(reader);
}
}
return(item);
}
private static PaymentTran GetItemFromReader(IDataReader dataReader)
{
PaymentTran objItem = new PaymentTran();
objItem.RefNbr = SqlHelper.GetString(dataReader, "RefNbr");
objItem.PayAmount = SqlHelper.GetDecimal(dataReader, "PayAmount");
objItem.CuryId = SqlHelper.GetString(dataReader, "CuryId");
objItem.PayDate = SqlHelper.GetDateTime(dataReader, "PayDate");
objItem.CreatedUser = SqlHelper.GetString(dataReader, "CreatedUser");
return(objItem);
}