private void LoadValues() { if (!string.IsNullOrEmpty(sw.ManagerID.ToString())) { SelectGM.SelectedIndex = Convert.ToInt16(sw.ManagerID); } if (!string.IsNullOrEmpty(sw.StoreID.ToString())) { SelectStore.SelectedIndex = Convert.ToInt16(sw.StoreID); } if (string.IsNullOrEmpty(sw.visitDate)) { sw.visitDate = DateTime.Now.Date.ToShortDateString(); } if (string.IsNullOrEmpty(sw.arrivalTime)) { sw.arrivalTime = DateTime.Now.ToShortTimeString(); } //find contact report data for logged in store manager and created today System.Data.DataTable dt = dc.GetEditableContactReport(sw.StoreID, sw.ManagerID, DateTime.Now.Date); //if found, make SelectGM, SelectStore non-editable string departureTime = string.Empty; if (dt.Rows.Count > 0) { SelectGM.SelectedIndex = Convert.ToInt16(dt.Rows[0]["Manager"]); SelectGM.Disabled = true; SelectStore.SelectedIndex = Convert.ToInt16(dt.Rows[0]["Store"]); SelectStore.Disabled = true; sw.visitDate = Utilities.MakeDateTime(dt.Rows[0]["VisitDate"].ToString()).ToShortDateString(); sw.arrivalTime = dt.Rows[0]["ArrivalTime"].ToString(); sw.VisitID = Convert.ToInt16(dt.Rows[0]["id"]); Visit_Date.Value = sw.visitDate; departureTime = dt.Rows[0]["DepartureTime"].ToString(); UnitsSold_Today.Value = dt.Rows[0]["UnitsSold_Today"].ToString(); UnitsSoldGP_Today.Value = Utilities.TwoDecimals(dt.Rows[0]["UnitsSoldGP_Today"]); //GPPUToday.Value = Utilities.ProfitPerUnit(UnitsSoldGP_Today.Value, UnitsSold_Today.Value).ToString(); UnitsDelivered_MTD.Value = dt.Rows[0]["UnitsDelivered_MTD"].ToString(); UnitsSoldTotalGP_MTD.Value = Utilities.TwoDecimals(dt.Rows[0]["UnitsSoldTotalGP_MTD"]); //MTDGPPU.Value = Utilities.ProfitPerUnit(UnitsSoldTotalGP_MTD.Value,UnitsDelivered_MTD.Value); ReadyForSaleStatus.Value = dt.Rows[0]["ReadyForSaleStatus"].ToString(); ModelMix.Value = dt.Rows[0]["ModelMix"].ToString(); PricingAge.Value = dt.Rows[0]["PricingVsAge"].ToString(); boGrossProfit_Today.Value = Utilities.TwoDecimals(dt.Rows[0]["boGrossProfit_Today"]); boCloses_Today.Value = dt.Rows[0]["boCloses_Today"].ToString(); // boGPPU_Today.Value = dt.Rows[0]["boGPPU_Today"].ToString(); //boGPPU_Today.Value = Utilities.ProfitPerUnit(boGrossProfit_Today.Value, boCloses_Today.Value); boGrossProfit_MTD.Value = Utilities.TwoDecimals(dt.Rows[0]["boGrossProfit_Today"]); boCloses_MTD.Value = dt.Rows[0]["boCloses_MTD"].ToString(); partsSales_MTD.Value = Utilities.TwoDecimals(dt.Rows[0]["partsSales_MTD"]); ServiceSales_MTD.Value = Utilities.TwoDecimals(dt.Rows[0]["ServiceSales_MTD"]); Displays.Value = dt.Rows[0]["Displays"].ToString(); Cleanliness_Organization.Value = dt.Rows[0]["Cleanliness_Organization"].ToString(); OverallConditions.Value = dt.Rows[0]["OverallConditions"].ToString(); Improve.Value = dt.Rows[0]["Improve"].ToString(); StaffingReview.Value = dt.Rows[0]["StaffingReview"].ToString(); WebsiteSales.Value = dt.Rows[0]["WebsiteSales"].ToString(); WebsiteBusOff.Value = dt.Rows[0]["WebsiteBusOff"].ToString(); WebsiteService.Value = dt.Rows[0]["WebsiteService"].ToString(); WebsiteParts.Value = dt.Rows[0]["WebsiteParts"].ToString(); //determine if remainder of form can be edited by checking today's date if (DateTime.Now.Date > Convert.ToDateTime(sw.visitDate).Date) { DisableElements(); } } else { Visit_Date.Value = DateTime.Now.ToShortDateString(); sw.visitDate = Visit_Date.Value; } }
private void LoadValues() { if (!string.IsNullOrEmpty(sw.ManagerID.ToString())) { SelectGM.SelectedIndex = Convert.ToInt16(sw.ManagerID); } if (!string.IsNullOrEmpty(sw.StoreID.ToString())) { SelectStore.SelectedIndex = Convert.ToInt16(sw.StoreID); } if (!string.IsNullOrEmpty(sw.visitDate)) { sw.visitDate = DateTime.Now.Date.ToShortDateString(); } if (!string.IsNullOrEmpty(sw.arrivalTime)) { sw.arrivalTime = DateTime.Now.ToShortTimeString(); } //find contact report data for logged in store manager and created today System.Data.DataTable dt = dc.GetEditableContactReport(sw.StoreID, sw.UserID, DateTime.Now.Date); //if found, make SelectGM, SelectStore non-editable string departureTime = string.Empty; if (dt.Rows.Count > 0) { SelectGM.SelectedIndex = Convert.ToInt16(dt.Rows[0]["ManagerID"]); SelectGM.Disabled = true; SelectStore.SelectedIndex = Convert.ToInt16(dt.Rows[0]["StoreID"]); SelectStore.Disabled = true; sw.visitDate = dt.Rows[0]["VisitDate"].ToString(); //determine if remainder of form can be edited by checking today's date if (DateTime.Now.Date > Convert.ToDateTime(sw.visitDate).Date) { //show db values, disable all inputs departureTime = dt.Rows[0]["DepartureTime"].ToString(); UnitsSold_Today.Value = dt.Rows[0]["UnitsSold_Today"].ToString(); UnitsSoldGP_Today.Value = dt.Rows[0]["UnitsSoldGP_Today"].ToString(); UnitsDelivered_MTD.Value = dt.Rows[0]["UnitsDelivered_MTD"].ToString(); UnitGoalAchieved.Value = dt.Rows[0]["UnitGoalAchieved"].ToString(); UnitsSoldTotalGP_MTD.Value = dt.Rows[0]["UnitsSoldTotalGP_MTD"].ToString(); GPGoalAchieved.Value = dt.Rows[0]["GPGoalAchieved"].ToString(); MTDGPPU.Value = dt.Rows[0]["MTDGPPU"].ToString(); UsedReady.Value = dt.Rows[0]["UsedReady"].ToString(); ModelMix.Value = dt.Rows[0]["ModelMix"].ToString(); PricingAge.Value = dt.Rows[0]["PricingAge"].ToString(); boGrossProfit_Today.Value = dt.Rows[0]["boGrossProfit_Today"].ToString(); boCloses_Today.Value = dt.Rows[0]["boCloses_Today"].ToString(); boGPPU_Today.Value = dt.Rows[0]["boGPPU_Today"].ToString(); boGrossProfit_MTD.Value = dt.Rows[0]["boGPPU_Today"].ToString(); boCloses_MTD.Value = dt.Rows[0]["boGPPU_Today"].ToString(); boGoal.Value = dt.Rows[0]["boGoal"].ToString(); boGoalAchievement.Value = dt.Rows[0]["boGoalAchievement"].ToString(); partsSales_MTD.Value = dt.Rows[0]["partsSales_MTD"].ToString(); partsGoal_MTD.Value = dt.Rows[0]["partsGoal_MTD"].ToString(); partsGoalAchieve.Value = dt.Rows[0]["partsGoalAchieve"].ToString(); ServiceSales_MTD.Value = dt.Rows[0]["ServiceSales_MTD"].ToString(); ServiceGoal_MTD.Value = dt.Rows[0]["ServiceGoal_MTD"].ToString(); ServGoalAchivement.Value = dt.Rows[0]["ServiceGoalAchivement"].ToString(); CustomerIssues.Value = dt.Rows[0]["CustomerIssues"].ToString(); EmployeesTrained.Value = dt.Rows[0]["EmployeesTrained"].ToString(); DisableElements(); } } }