public async void ExecuteAddQuotationCommand()
{
MIQuotation insuranceDetail = this.QuotationViewModel.CurrentInsuranceDetail.Model;
if (insuranceDetail != null)
{
string quotationNo = DbUtility.GetNewQuotationNumber(quotationDb);
insuranceDetail.NRIC = this.QuotationViewModel.OwnerDetail.NRIC;
insuranceDetail.InsuranceQtnNo = quotationNo;
var errorInfo = quotationDb.AddInsuranceDetails(insuranceDetail);
if (errorInfo.Code == 0)
{
this.IsQuotationAdded = false;
string errorMessage;
this.QuotationDataSet = quotationDb.GetMIQuoationDetails(quotationNo, out errorMessage);
//if(String.IsNullOrEmpty(errorMessage) == true)
//{
// NavigationParameters navParameters = new NavigationParameters();
// navParameters.Add("ReportDataSet", quotationDataSet);
// this.RegionManager.RequestNavigate(RegionNames.MotorWizardRegion, PopupNames.ReportModule_Motor, navParameters);
//}
//else
//{
// await this.Container.Resolve<IMetroMessageDisplayService>(ServiceNames.MetroMessageDisplayService).ShowMessageAsnyc("Renew Quotation", errorMessage);
// return;
//}
}
else
{
await this.Container.Resolve <IMetroMessageDisplayService>(ServiceNames.MetroMessageDisplayService).ShowMessageAsnyc("Renew Quotation", errorInfo.Info);
return;
}
//On Successfully creating a new quotation
this.EventAggregator.GetEvent <NewQuotationEvent>().Publish(new QuotationEventArgs
{
QuotationNumber = insuranceDetail.InsuranceQtnNo,
OwnerName = this.QuotationViewModel.OwnerDetail.Name,
NRICNumber = insuranceDetail.NRIC,
QuotationDataSet = quotationDataSet
});
}
else
{
await this.Container.Resolve <IMetroMessageDisplayService>(ServiceNames.MetroMessageDisplayService).ShowMessageAsnyc("Renew Quotation", "Unable to add Insurance details");
return;
}
}
public async Task <IHttpActionResult> UpdateMIQuotation([FromBody] MIQuotation quotationDetail)
{
try
{
ErrorDetail errorDetail = await Task.Run(() => quotationDb.UpdateMIQuotation(quotationDetail));
if (errorDetail == null)
{
return(NotFound());
}
return(Ok(errorDetail));
}
catch (Exception)
{
return(InternalServerError());
}
}
internal ErrorDetail UpdateMIQuotation(MIQuotation quotationDetail)
{
Dictionary <string, SqlParameter> cmdParameters = new Dictionary <string, SqlParameter>();
cmdParameters["NRIC"] = new SqlParameter("NRIC", quotationDetail.NRIC);
cmdParameters["InsuranceQtnNo"] = new SqlParameter("InsuranceQtnNo", quotationDetail.InsuranceQtnNo);
cmdParameters["InsuranceExpiryDate"] = new SqlParameter("InsuranceExpiryDate", quotationDetail.InsuranceExpiryDate);
cmdParameters["InsuranceRenewalDate"] = new SqlParameter("InsuranceRenewalDate", quotationDetail.InsuranceExpiryDate);
cmdParameters["RoadTaxExpiryDate"] = new SqlParameter("RoadTaxExpiryDate", quotationDetail.RoadTaxExpiryDate);
cmdParameters["RoadTaxRenewalDate"] = new SqlParameter("RoadTaxRenewalDate", quotationDetail.RoadTaxExpiryDate);
cmdParameters["PreviousDealer"] = new SqlParameter("PreviousDealer", quotationDetail.PreviousDealer ?? "NIL");
cmdParameters["Agency"] = new SqlParameter("Agency", quotationDetail.Agency ?? "NIL");
cmdParameters["PrevYearPremium"] = new SqlParameter("PrevYearPremium", quotationDetail.PrevYearPremium ?? "NIL");
cmdParameters["FinanceBank"] = new SqlParameter("FinanceBank", quotationDetail.FinanceBank);
cmdParameters["InsuranceRenewed"] = new SqlParameter("InsuranceRenewed", quotationDetail.InsuranceRenewed);
cmdParameters["RoadTaxRenewed"] = new SqlParameter("RoadTaxRenewed", quotationDetail.RoadTaxRenewed);
SqlParameter outPutParameter1 = new SqlParameter();
outPutParameter1.ParameterName = "ERRORNO";
outPutParameter1.SqlDbType = System.Data.SqlDbType.Int;
outPutParameter1.Size = 255;
outPutParameter1.Direction = System.Data.ParameterDirection.Output;
cmdParameters["ERRORNO"] = outPutParameter1;
SqlParameter outPutParameter2 = new SqlParameter();
outPutParameter2.ParameterName = "ERRORDESC";
outPutParameter2.SqlDbType = System.Data.SqlDbType.VarChar;
outPutParameter2.Size = 255;
outPutParameter2.Direction = System.Data.ParameterDirection.Output;
cmdParameters["ERRORDESC"] = outPutParameter2;
ErrorDetail errorDetail = new ErrorDetail();
dbutility.ExecuteNonQuery("QuotationDb", "dbo.UpdateMIQuotation", cmdParameters);
errorDetail.Code = outPutParameter1.Value == null ? -1 : int.Parse(outPutParameter1.Value.ToString());
errorDetail.Info = outPutParameter2.Value == null ? "ERROR" : outPutParameter2.Value.ToString();
return(errorDetail);
}
public ErrorDetail AddInsuranceDetails(MIQuotation quotationDetail)
{
ErrorDetail errorDetail = new ErrorDetail();
try
{
HttpResponseMessage responseMessage = client.PostAsJsonAsync("/api/Quotation/AddInsuranceDetails", quotationDetail).Result;
if (responseMessage.IsSuccessStatusCode)
{
string data = responseMessage.Content.ReadAsStringAsync().Result;
errorDetail = JsonConvert.DeserializeObject <ErrorDetail>(data);
}
else
{
errorDetail.Info = responseMessage.ReasonPhrase;
}
}
catch (Exception ex)
{
errorDetail.Info = ex.Message;
}
return(errorDetail);
}
public ErrorDetail EditInsuranceDetails(MIQuotation insuranceDetail)
{
return(new ErrorDetail());
}
