/// <summary>
/// Function to get particular values from FinancialYear table based on the parameter
/// </summary>
/// <param name="financialYearId"></param>
/// <returns></returns>
public FinancialYearModel FinancialYearViewForAccountLedger(decimal financialYearId)
{
FinancialYearModel financialyearinfo = new FinancialYearModel();
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@S_financialYearId", financialYearId));
IDataReader sdrreader = _dbHelper.ExecuteDataReader("spFinancialYearViewForAccountLedger", _dbHelper.GetConnObject(), CommandType.StoredProcedure);
while (sdrreader.Read())
{
financialyearinfo.FinancialYearId = decimal.Parse(sdrreader[0].ToString());
financialyearinfo.FromDate = DateTime.Parse(sdrreader[1].ToString());
}
}
catch (Exception ex)
{
}
finally
{
}
return(financialyearinfo);
}
private async Task <FinancialYearModel> AssignValueToModel(Financialyear financialYear)
{
return(await Task.Run(() =>
{
FinancialYearModel financialYearModel = new FinancialYearModel();
financialYearModel.FinancialYearId = financialYear.FinancialYearId;
financialYearModel.FinancialYearName = financialYear.FinancialYearName;
financialYearModel.FromDate = financialYear.FromDate;
financialYearModel.ToDate = financialYear.ToDate;
financialYearModel.PreparedByName = null != financialYear.PreparedByUser ? financialYear.PreparedByUser.UserName : null;
return financialYearModel;
}));
}