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(); }