public static string GetNewQuotationNumber(QuotationDb dbContext)
{
string quotationNo = string.Empty;
string errorMessage;
var qtndataset = dbContext.LoadComboDetails("QTN", out errorMessage);
if (qtndataset != null && qtndataset.Tables.Count > 0)
{
var qtnDetails = GetInsuranceDetail(qtndataset.Tables[0]);
var quotationNos = qtnDetails.Select(q => int.Parse(q.InsuranceQtnNo));
int max = 10000;
if (quotationNos != null && quotationNos.Count() == 0)
{
max = 10000;
}
else
{
max = quotationNos.Max();
}
quotationNo = (max + 1).ToString();
}
else
{
quotationNo = "1001";
}
return(quotationNo);
}
public async Task <IHttpActionResult> LoadComboDetails(string flag)
{
try
{
DataSet details = await Task.Run(() => quotationDb.LoadComboDetails(flag));
if (details == null)
{
return(NotFound());
}
return(Ok(details));
}
catch (Exception)
{
return(InternalServerError());
}
}