private void bindControls() { if (q == null) { q = new BusinessObjects.Quote(); } txtQuoteNo.Text = q.QuoteNumber; if (cbxCustomer.Items.Count < 2) { cbxCustomer.DataSource = Functions.DB.GetCustomers(q.Customer, 0, 1); cbxCustomer.DataBind(); } if (cbxCustomer.Items.Count(i => i.Text == q.Customer) > 0) { cbxCustomer.SelectedIndex = cbxCustomer.Items.IndexOf(cbxCustomer.Items.First(i => i.Text == q.Customer)); } txtContact.Text = q.CustomerContact; txtTelephone.Text=q.CustomerPhone; txtFax.Text=q.CustomerFax; txtCustRef.Text=q.CustomerReferenceNo; if (ddPickupCity.Items.Count < 2) { ddPickupCity.DataSource = Functions.DB.GetPlaces(q.PickupCity, 0, 1); ddPickupCity.DataBind(); } if (ddPickupCity.Items.Count(i => i.Text == q.PickupCity) > 0) { ddPickupCity.SelectedIndex = ddPickupCity.Items.IndexOf(ddPickupCity.Items.First(i => i.Text == q.PickupCity)); } if (ddcustState.Items.Count < 2) { ddcustState.DataBind(); } if (ddcustState.Items.Count(i => i.Text == q.CustomerState) > 0) { ddcustState.SelectedIndex = ddcustState.Items.IndexOf(ddcustState.Items.First(i => i.Text == q.CustomerState)); } txtcustZip.Text=q.CustomerZip; if (ddPortofLoad.Items.Count < 2) { ddPortofLoad.DataSource = Functions.DB.GetPorts(q.PortOfLoad, 0, 1); ddPortofLoad.DataBind(); } if (ddPortofLoad.Items.Count(i => i.Text == q.PortOfLoad) > 0) { ddPortofLoad.SelectedIndex = ddPortofLoad.Items.IndexOf(ddPortofLoad.Items.First(i => i.Text == q.PortOfLoad)); } if (ddPortOfDispatch.Items.Count < 2) { ddPortOfDispatch.DataSource = Functions.DB.GetPorts(q.PortOfDispatch, 0, 1); ddPortOfDispatch.DataBind(); } if (ddPortOfDispatch.Items.Count(i => i.Text == q.PortOfDispatch) > 0) { ddPortOfDispatch.SelectedIndex = ddPortOfDispatch.Items.IndexOf(ddPortOfDispatch.Items.First(i => i.Text == q.PortOfDispatch)); } if (ddFinalDestination.Items.Count < 2) { ddFinalDestination.DataSource = Functions.DB.GetPlaces(q.FinalDestination, 0, 1); ddFinalDestination.DataBind(); } if (ddFinalDestination.Items.Count(i => i.Value == q.FinalDestination) > 0) { ddFinalDestination.SelectedIndex = ddFinalDestination.Items.IndexOf(ddFinalDestination.Items.First(i => i.Value == q.FinalDestination)); } txtDestZip.Text=q.DestinationZip; if (ddDestCountry.Items.Count < 2) { ddDestCountry.DataBind(); } if (ddDestCountry.Items.Count(i => i.Text == q.DestinationCountry) >0) { ddDestCountry.SelectedIndex =ddDestCountry.Items.IndexOf( ddDestCountry.Items.First(i=>i.Text==q.DestinationCountry)); } if (ddTypeOfMove.Items.Count < 2) { ddTypeOfMove.DataSource = Functions.DB.GetServiceTypes(q.TypeOfMove, 0, 1); ddTypeOfMove.DataBind(); } if (ddTypeOfMove.Items.Count(i => i.Text == q.TypeOfMove) >0) { ddTypeOfMove.SelectedIndex= ddTypeOfMove.Items.IndexOf(ddTypeOfMove.Items.First(i => i.Text == q.TypeOfMove)); } txtQuoteNo.Text = q.QuoteNumber; ddDivision.SelectedValue = ddDivision.Items.FindByValue(q.Division) != null ? q.Division : string.Empty; ddBusinessLine.SelectedValue = ddBusinessLine.Items.FindByValue(q.Businessline) != null ? q.Businessline : string.Empty; txtINCOTerms.Text=q.INCOTerms; txtINCOLocation.Text=q.INCOTermsLocation; txtEffextiveDate.Text= q.Effectivdate==DateTime.MinValue?"": q.Effectivdate.ToShortDateString(); txtExpirationDate.Text = q.ExpirationDate == DateTime.MinValue ? "" : q.ExpirationDate.ToShortDateString(); txtQuotedBy.Text=q.QuotedBy; if (ddSalesRep.Items.Count < 2) { ddSalesRep.DataBind(); } if (ddSalesRep.Items.Count(i => i.Value == q.SalesRep) > 0) { ddSalesRep.SelectedIndex = ddSalesRep.Items.IndexOf(ddSalesRep.Items.First(i => i.Value == q.SalesRep)); } ddPreferredCarrier.SelectedValue = ddPreferredCarrier.Items.FindByText(q.PreferredCarrier) != null ? q.PreferredCarrier : string.Empty; txtVoyage.Text=q.Voyage; ddVessel.SelectedValue = ddVessel.Items.FindByText(q.Vessel) != null ? q.Vessel : string.Empty; ddContainerHandling.SelectedValue=ddContainerHandling.Items.FindByText(q.ContainerHandling) != null ? q.ContainerHandling : string.Empty; bindgrid(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) {//QuoteNo = "000111"; if (q!=null && q.QuoteNumber != null && q.QuoteNumber != string.Empty) { lblQuoteNO.Text = q.QuoteNumber; } bindDropdowns("ddDivision"); bindDropdowns("ddPreferredCarrier"); if (ViewState["Quote"] != null) { q = (BusinessObjects.Quote)ViewState["Quote"]; } bindControls(); Session["Quote"] = null; } else { //I'm using the session state here because the Viewstate has not been holding the changes consistently if (Session["Quote"] != null) { q = (BusinessObjects.Quote)Session["Quote"]; Session["Quote"] = null; ViewState["Quote"] = q; } else if (ViewState["Quote"] != null) { q = (BusinessObjects.Quote)ViewState["Quote"]; } } }
private static BusinessObjects.Quote populateQuoteFromDataRow(DataRow row) { BusinessObjects.Quote q = new BusinessObjects.Quote(); q.ID = int.Parse(row["ID"].ToString()); q.QuoteNumber = row["REFERENCE_NO"].ToString(); q.Customer = row["SHIPPER_NAME"].ToString().Trim(); q.CustomerCode = row["SHIPPER"].ToString().Trim(); q.CustomerContact = row["SHIPPER_CONTACT"].ToString(); q.CustomerPhone = row["SHIPPER_PHONE"].ToString(); q.CustomerFax = row["SHIPPER_FAX"].ToString(); q.CustomerReferenceNo = row["P_O_NUMBER"].ToString(); q.PickupCity = row["PLR"].ToString().Trim(); q.CustomerState = row["SUPPLIER_STATE"].ToString().Trim(); q.CustomerZip = row["SUPPLIER_ZIP_CODE"].ToString(); q.PortOfLoad = row["POL"].ToString().Trim(); q.PortOfDispatch = row["POD"].ToString().Trim(); q.FinalDestination = row["FinalDestino"].ToString(); q.DestinationZip = row["CONSIGNEE_ZIP_CODE"].ToString(); q.DestinationCountry = row["CONSIGNEE_COUNTRY"].ToString().Trim(); q.TypeOfMove = row["MOVE_TYPE"].ToString().Trim(); q.Division = row["PAYMENT"].ToString().Trim(); q.Businessline = row["BUS_LINE"].ToString().Trim(); q.INCOTerms = row["Incoterms"].ToString(); q.INCOTermsLocation = row["IncotermsLocation"].ToString(); DateTime effdate; DateTime.TryParse(row["EFFECTIVE_DATE"].ToString(), out effdate); q.Effectivdate = effdate; DateTime expdate; DateTime.TryParse(row["EXPIRATION_DATE"].ToString(), out expdate); q.ExpirationDate = expdate; q.QuotedBy = row["QuotedBy"].ToString(); q.SalesRep = row["CONTROLLER"].ToString(); q.PreferredCarrier = row["CARRIER"].ToString(); q.Voyage = row["Voyage"].ToString(); q.Vessel = row["Vessel"].ToString(); q.ContainerHandling = row["ContainerHandeling"].ToString(); q.Containers = GetContainers(q.QuoteNumber); return q; }
protected void lvContainers_ItemCanceling(object sender, ListViewCancelEventArgs e) { lvContainers.EditIndex = -1; lvContainers.InsertItemPosition = InsertItemPosition.None; q = (BusinessObjects.Quote) ViewState["BeforeEdit"]; bindControls(); ViewState["Quote"] = q; }
public static BusinessObjects.Quote getQuote(string quoteno) { string sql = string.Empty; if (quoteno == null || quoteno == string.Empty) { sql = @"SELECT Top 0 ID, REFERENCE_NO, CONTROLLER, EFFECTIVE_DATE, EXPIRATION_DATE, SHIPPER, SHIPPER_NAME, SHIPPER_CONTACT, SHIPPER_PHONE, SHIPPER_FAX, COMMODITY, MOVE_TYPE, PAYMENT, P_O_NUMBER, PLR, POL, POD, SUPPLIER_STATE, SUPPLIER_ZIP_CODE, CONSIGNEE_STATE, CONSIGNEE_ZIP_CODE, CONSIGNEE_COUNTRY, CARRIER, BUS_LINE, IncotermsLocation, ContainerHandeling, Booking_UID ,Voyage,FinalDestino,QuotedBY FROM QUOTES_DAT order by effective_date desc"; } else { sql = @"SELECT Top 1 ID, REFERENCE_NO, CONTROLLER, EFFECTIVE_DATE, EXPIRATION_DATE, SHIPPER, SHIPPER_NAME, SHIPPER_CONTACT, SHIPPER_PHONE, SHIPPER_FAX, COMMODITY, MOVE_TYPE, PAYMENT, P_O_NUMBER, PLR, POL, POD, SUPPLIER_STATE, SUPPLIER_ZIP_CODE, CONSIGNEE_STATE, CONSIGNEE_ZIP_CODE, CONSIGNEE_COUNTRY, CARRIER, BUS_LINE, Incoterms, IncotermsLocation, ContainerHandeling, Booking_UID ,Voyage,FinalDestino,QuotedBY,Vessel FROM QUOTES_DAT where REFERENCE_NO=? order by effective_date desc"; } DataTable dt = new DataTable(); using (OdbcDataAdapter adp = new OdbcDataAdapter(sql, Properties.Settings.Default.IESDBConn)) { adp.SelectCommand.Parameters.Add(new OdbcParameter("@ID", quoteno)); adp.Fill(dt); } BusinessObjects.Quote q = new BusinessObjects.Quote(); if (dt.Rows.Count > 0) { q = populateQuoteFromDataRow(dt.Rows[0]); return q; } return null; }