public static int IsQuoteExisted(int usercredentialsId)
{
FuelQuoteModel data = new FuelQuoteModel
{
UserCredentialsID = usercredentialsId
};
string sql = @"SELECT Id FROM dbo.FuelQuote WHERE UserCredentialsID = @UserCredentialsID;";
return(sqlDataAccess.IsExist(sql, data));
}
public static int InsertFuelQuoteInformation(double gallons, string deliveryAddress, DateTime deliveryDate,
double suggestedPrice, double amountDue, int usercredentialsId)
{
FuelQuoteModel data = new FuelQuoteModel
{
Gallons = gallons,
DeliveryAddress = deliveryAddress,
DeliveryDate = deliveryDate,
SuggestedPrice = suggestedPrice,
TotalAmountDue = amountDue,
UserCredentialsID = usercredentialsId
};
string sql = @"insert into FuelQuote (Gallons, DeliveryDate, UserCredentialsId, DeliveryAddress, TotalAmountDue, SuggestedPrice)
values(@Gallons, @DeliveryDate, @UserCredentialsId, @DeliveryAddress, @TotalAmountDue, @SuggestedPrice);";
return(sqlDataAccess.SaveData(sql, data));
}
public ActionResult Generate(FuelQuoteModel model)
{
if (ModelState.IsValid)
{
HttpCookie cookie = Request.Cookies["UserInfo"];
if (cookie != null)
{
model.UserCredentialsID = Int32.Parse(cookie["UserID"]);
}
model.DeliveryAddress = ClientProfileProcessor.GetClientAddress(model.UserCredentialsID);
int RateHistory = FuelQuoteFormProcessor.IsQuoteExisted(model.UserCredentialsID);
model.SuggestedPrice = PriceModule.PriceCalculation(1.5, ClientProfileProcessor.GetClientState
(model.UserCredentialsID), RateHistory, model.Gallons);
model.TotalAmountDue = model.SuggestedPrice * model.Gallons;
FuelQuoteFormProcessor.InsertFuelQuoteInformation(model.Gallons, model.DeliveryAddress,
model.DeliveryDate, model.SuggestedPrice, model.TotalAmountDue, model.UserCredentialsID);
return(RedirectToAction("Index", "Client"));
}
return(View());
}
