public ITReturnProvisionReportResponse GetITReturnProvisions(int CompanyId, int NoOfYears)
{
ITReturnProvisionReportResponse _response = null;
try
{
Log.Info("GetITReturnProvisions.Start");
Log.Info("parameter values" + JsonConvert.SerializeObject(new { companyId = CompanyId, noOfYears = NoOfYears }));
Command.CommandText = "SP_GET_ITR_TAX_PROVISION_REPORT";
Command.CommandType = CommandType.StoredProcedure;
Command.Parameters.Clear();
Command.Parameters.AddWithValue("@COMPANY_ID", CompanyId);
Command.Parameters.AddWithValue("@NO_OF_YEARS", NoOfYears);
Connection.Open();
SqlDataReader reader = Command.ExecuteReader();
_response = new ITReturnProvisionReportResponse();
if (reader.HasRows)
{
_response.IsSuccess = true;
while (reader.Read())
{
_response.ITReturnProvisions.Add(new ITReturnProvisionReport()
{
FYAYId = int.Parse(reader["FYAYID"].ToString()),
FinancialYear = reader["FinancialYear"] != DBNull.Value ? reader["FinancialYear"].ToString() : string.Empty,
TaxProvisions = decimal.Parse(reader["TaxProvisions"].ToString()),
TaxAssets = decimal.Parse(reader["TaxAssets"].ToString()),
ContingentLiabilities = decimal.Parse(reader["ContingentLiabilities"].ToString())
});
}
}
else
{
_response.IsSuccess = false;
_response.Message = "No data found";
}
}
catch (Exception ex)
{
Log.Error("GetITReturnProvisions.Error:" + JsonConvert.SerializeObject(ex));
LogError(ex);
throw;
}
finally
{
Connection.Close();
Log.Info("GetITReturnProvisions.End");
}
return(_response);
}
public async Task <ActionResult> ITReturnProvisions(int companyId, int noOfYears)
{
ITReturnProvisionReportResponse resModel = null;
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(ConfigurationManager.AppSettings["BaseUrl"]);
client.DefaultRequestHeaders.Clear();
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
HttpResponseMessage Res = await client.GetAsync("api/CompanyDashboardAPI/ITReturnProvisions?companyId=" + companyId.ToString() + "&NoOfYears=" + noOfYears.ToString());
if (Res.IsSuccessStatusCode)
{
resModel = JsonConvert.DeserializeObject <ITReturnProvisionReportResponse>(Res.Content.ReadAsStringAsync().Result);
}
}
return(Json(resModel, JsonRequestBehavior.AllowGet));
}
