public IHttpActionResult GetQuotationCountForLastTweleveMonthsCompleted(int VendorId)
{
DisplayMultiChart objDispChart = new DisplayMultiChart();
try
{
objDispChart = objVDVM.GetQuotationCountForLastTweleveMonthsCompleted(VendorId);
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(Ok(new { results = objDispChart }));
}
public DisplayMultiChart GetQuotationCountForLastTweleveMonthsCompleted(int VendorId)
{
DisplayMultiChart objModel = new DisplayMultiChart();
try
{
List <string> CountList = new List <string>();
List <string> MonList = new List <string>();
List <string> MonList1 = new List <string>();
string sqlstr = "Select sum(count) as count, ''''+mon+'''' as mon from ACRFVW_GetLastTweleveMonthQuotationCountWithStatus "
+ " where VendorId in (0," + VendorId + ") and QuotationStatus in ('','" + QuotationType.Completed + "') group by yyyy,mon,mon_number order by mon_number";
var connection = gConnection.Connection();
connection.Open();
SqlCommand cmd = new SqlCommand(sqlstr, connection);
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
CountList.Add(sdr["count"].ToString());
MonList.Add(sdr["mon"].ToString());
}
sdr.Close();
objModel.Count1 = CountList;
objModel.Text = MonList;
sqlstr = "Select sum(count) as count, ''''+mon+'''' as mon from ACRFVW_GetLastTweleveMonthQuotationCountWithStatus "
+ " where VendorId in (0," + VendorId + ") group by yyyy,mon,mon_number order by mon_number";
cmd.Parameters.Clear();
cmd.Connection = connection;
cmd.CommandText = sqlstr;
sdr = cmd.ExecuteReader();
while (sdr.Read())
{
MonList1.Add(sdr["count"].ToString());
}
sdr.Close();
objModel.Count2 = MonList1;
connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(objModel);
}
