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); }