private OpenBalancePaymentVm PopulateOpenBalancePaymentFromIDataReader(IDataReader reader)
{
OpenBalancePaymentVm hosCon = new OpenBalancePaymentVm();
if (reader["AccountId"] != DBNull.Value)
{
hosCon.AccountId = (string)reader["AccountId"];
}
if (reader["CurrencyId"] != DBNull.Value)
{
hosCon.CurrencyId = (int)reader["CurrencyId"];
}
if (reader["DebitAmount"] != DBNull.Value)
{
hosCon.DebitAmount = (decimal)reader["DebitAmount"];
}
if (reader["CreditAmount"] != DBNull.Value)
{
hosCon.CreditAmount = (decimal)reader["CreditAmount"];
}
if (reader["Amount"] != DBNull.Value)
{
hosCon.Amount = (decimal)reader["Amount"];
}
if (reader["IsCredit"] != DBNull.Value)
{
hosCon.IsCredit = (int)reader["IsCredit"];
}
if (reader["AccountNameEn"] != DBNull.Value)
{
hosCon.AccountNameEn = (string)reader["AccountNameEn"];
}
if (reader["AccountNameAr"] != DBNull.Value)
{
hosCon.AccountNameAr = (string)reader["AccountNameAr"];
}
if (reader["CurrencySign"] != DBNull.Value)
{
hosCon.CurrencySign = (string)reader["CurrencySign"];
}
if (reader["CurrencyName"] != DBNull.Value)
{
hosCon.CurrencyName = (string)reader["CurrencyName"];
}
return(hosCon);
}
public OpenBalancePaymentVm Get_OpenBalanceObject(string accid, int cid)
{
OpenBalancePaymentVm openBalanceObj = null;
using (SqlConnection myConnection = GetSqlConnection())
{
SqlCommand myCommand = new SqlCommand("OpenBalance_GetObject", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.AddWithValue("@AccountId", accid);
myCommand.Parameters.AddWithValue("@CurrencyId", cid);
myConnection.Open();
using (SqlDataReader dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection))
{
if (dr.Read())
{
openBalanceObj = PopulateOpenBalancePaymentFromIDataReader(dr);
}
dr.Close();
}
myConnection.Close();
return(openBalanceObj);
}
}
