public IHttpActionResult GetQuotationStatus(int VendorId)
{
QuotationStatusCount objModel = new QuotationStatusCount();
objModel = objVDVM.GetQuotationStatus(VendorId);
return(Ok(new { results = objModel }));
}
public QuotationStatusCount GetQuotationStatus(int VendorId)
{
QuotationStatusCount objModel = new QuotationStatusCount();
try
{
string sqlstr = "Select Count(*) As Cnt, QuotationStatus From ACRF_Quotation where VendorId=@VendorId Group By QuotationStatus";
var connection = gConnection.Connection();
connection.Open();
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.AddWithValue("@VendorId", VendorId);
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
if (sdr["QuotationStatus"].ToString() == QuotationType.Cancelled)
{
objModel.Cancelled = Convert.ToInt32(sdr["Cnt"].ToString());
}
if (sdr["QuotationStatus"].ToString() == QuotationType.Completed)
{
objModel.Completed = Convert.ToInt32(sdr["Cnt"].ToString());
}
if (sdr["QuotationStatus"].ToString() == QuotationType.InProgress)
{
objModel.InProgress = Convert.ToInt32(sdr["Cnt"].ToString());
}
if (sdr["QuotationStatus"].ToString() == QuotationType.OnHold)
{
objModel.OnHold = Convert.ToInt32(sdr["Cnt"].ToString());
}
}
sdr.Close();
connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(objModel);
}