public int UpdateVisit(clsContactReport contactReport)
{
try
{
int result = 0;
SqlCommand objCommand = new SqlCommand();
objCommand.Connection = con;
objCommand.CommandType = CommandType.StoredProcedure;
objCommand.CommandText = "dbo.spUpdateVisit";
objCommand.Parameters.AddWithValue("@id", contactReport.VisitId);
objCommand.Parameters.AddWithValue("@UnitsSold_Today", contactReport.UnitsSold_Today);
objCommand.Parameters.AddWithValue("@UnitsSoldGP_Today", contactReport.UnitsSoldGP_Today.ToString());
objCommand.Parameters.AddWithValue("@UnitsDelivered_MTD", contactReport.UnitsDelivered_MTD);
objCommand.Parameters.AddWithValue("@UnitsSoldTotalGP_MTD", contactReport.UnitsSoldTotalGP_MTD.ToString());
objCommand.Parameters.AddWithValue("@ReadyForSaleStatus", contactReport.ReadyForSaleStatus);
objCommand.Parameters.AddWithValue("@ModelMix", contactReport.ModelMix);
objCommand.Parameters.AddWithValue("@PricingVsAge", contactReport.PricingVsAge);
objCommand.Parameters.AddWithValue("@boCloses_Today", contactReport.boCloses_Today);
objCommand.Parameters.AddWithValue("@boGrossProfit_Today", contactReport.boGrossProfit_Today.ToString());
objCommand.Parameters.AddWithValue("@boCloses_MTD", contactReport.boCloses_MTD);
objCommand.Parameters.AddWithValue("@boGrossProfit_MTD", contactReport.boGrossProfit_MTD.ToString());
objCommand.Parameters.AddWithValue("@partsSales_MTD", contactReport.partsSales_MTD.ToString());
objCommand.Parameters.AddWithValue("@ServiceSales_MTD", contactReport.ServiceSales_MTD.ToString());
objCommand.Parameters.AddWithValue("@DepartureTime", contactReport.DepartureTime);
objCommand.Parameters.AddWithValue("@Displays", contactReport.Displays);
objCommand.Parameters.AddWithValue("@Cleanliness_Organization", contactReport.Cleanliness_Organization);
objCommand.Parameters.AddWithValue("@StaffingReview", contactReport.StaffingReview);
objCommand.Parameters.AddWithValue("@OverallConditions", contactReport.StaffingReview);
objCommand.Parameters.AddWithValue("@Improve", contactReport.Improve);
objCommand.Parameters.AddWithValue("@WebsiteSales", contactReport.WebsiteSales);
objCommand.Parameters.AddWithValue("@WebsiteBusOff", contactReport.WebsiteBusOff);
objCommand.Parameters.AddWithValue("@WebsiteService", contactReport.WebsiteService);
objCommand.Parameters.AddWithValue("@WebsiteParts", contactReport.WebsiteParts);
fnConOpen();
result = Convert.ToInt16(objCommand.ExecuteScalar());
fnConClose();
return(result);
}
catch (Exception)
{
throw;
}
}
protected void Page_Load(object sender, EventArgs e)
{
DatabaseCalls dc = new DatabaseCalls();
clsContactReport cr = new clsContactReport(Request);
cr.ArrivalTime = sw.arrivalTime;
if (!string.IsNullOrEmpty(sw.departureTime))
{
cr.DepartureTime = DateTime.Now.ToShortTimeString();
sw.departureTime = cr.DepartureTime;
}
cr.VisitDate = sw.visitDate;
cr.VisitId = dc.InsertVisit(cr);
var list = new List <clsContactReport> {
cr
};
DetailsView1.DataSource = list;
DetailsView1.DataBind();
}
