public void ContainerCargo_Saving(System.Collections.Hashtable rcd) { bool insrt = false; int id=-1; BusinessObjects.Container c; c= q.Containers[lvContainers.EditIndex]; BusinessObjects.ContainerCargo edit = new BusinessObjects.ContainerCargo(); if(int.TryParse(rcd["ID"].ToString(),out id)) { edit=(from crg in c.Cargo where crg.ID == int.Parse(rcd["ID"].ToString()) select crg).FirstOrDefault(); if (edit == null) {insrt = true; } }else{insrt = true;} edit.ID = id; int i; double d; bool b; edit.NetWeight = double.TryParse(rcd["NetWeight"].ToString(), out d) ? d : 0; i = 1; //int.TryParse(row["NetWeightUnit"].ToString(), out i); edit.NetWeightUnit = (BusinessObjects.Units.WeightUnits)i; i = 0; int.TryParse(rcd["Pieces"].ToString(), out i); edit.Pieces = i; edit.UOM = rcd["UOM"].ToString(); edit.Description = rcd["Description"].ToString(); d = 0; double.TryParse(rcd["GrossWeight"].ToString(), out d); edit.GrossWeight = d; i = 1; //int.TryParse(row["GrossWeightUnit"].ToString(), out i); edit.GrossWeightUnit = (BusinessObjects.Units.WeightUnits)i; edit.Hazardous = bool.TryParse(rcd["Hazardous"].ToString(), out b) ? b : false; if (insrt) { c.Cargo.Add(edit); } Session["Quote"] = q; ViewState["Quote"] = q; lvContainers.DataSource = q.Containers; lvContainers.DataBind(); }
public static List<BusinessObjects.ContainerCargo> GetCargo(int ContainerID) { DataTable dt = new DataTable(); string sql = string.Format(@"SELECT * FROM Cargo where ContainerID={0}", ContainerID); OdbcDataAdapter adp = new OdbcDataAdapter(sql, Properties.Settings.Default.IESDBConn); adp.Fill(dt); List<BusinessObjects.ContainerCargo> lc = new List<BusinessObjects.ContainerCargo>(); foreach (DataRow row in dt.Rows) { BusinessObjects.ContainerCargo c = new BusinessObjects.ContainerCargo(); c.ID = int.Parse(row["ID"].ToString()); c.Description = row["Description"].ToString(); int p; int.TryParse(row["Pieces"].ToString(),out p); c.Pieces = p; p = 0; c.UOM = row["UOM"].ToString(); int.TryParse(row["GrossWeight"].ToString(), out p); c.GrossWeight = p; p = 0; int.TryParse(row["GrossWeight"].ToString(), out p); c.NetWeight = p; bool h; bool.TryParse(row["Hazardous"].ToString(),out h); c.Hazardous = h; lc.Add(c); } return lc; }
//public void bindcontrols() //{ // if (c != null) // { // //txtContainerNo.Text = c.ContainerNumber; // //txtContainerType.Text = c.ContainerType; // //txtSeal1.Text = c.Seal1; // //txtSeal2.Text = c.Seal2; // //txtSeal3.Text = c.Seal3; // //txtTareWeight.Text = c.TareWeight; // //txtDischargeDate.Text=c.DischargeDate.ToShortDateString(); // //txtPickupDate.Text = c.PickupDate.ToShortDateString(); // //txtReturnDate.Text = c.ReturnDate.ToShortDateString(); // //txtCarrierPickup.Text = c.CarrierPickUpLastDate.ToShortDateString(); // //txtCustReturnLastFree.Text = c.CustomerReturnLastDate.ToShortDateString(); // //txtCustPickupLastFree.Text = c.CustomerPickupLastDate.ToShortDateString(); // //txtCarrierReturn.Text = c.CarrierReturnLastDate.ToShortDateString(); // //grCargo.DataSource = c.Cargo; // //grCargo.DataBind(); // } //} private void getContainerFromControls() { //Because of an error with viewstate. This will always be the original container before any edits deletes or inserts. //Viewstate is not holding updates. Only the first entry. if (c==null&&ViewState["Container"] != null) { c = (BusinessObjects.Container)ViewState["Container"]; } if (c==null){c = new BusinessObjects.Container();} c.ContainerNumber = txtContainerNo.Text; c.ContainerType = txtContainerType.Text; c.Seal1 = txtSeal1.Text; c.Seal2 = txtSeal2.Text; c.Seal3 = txtSeal3.Text; c.TareWeight = txtTareWeight.Text; DateTime dt = DateTime.MinValue; c.DischargeDate = DateTime.TryParse(txtDischargeDate.Text, out dt) ? dt : dt; c.PickupDate = DateTime.TryParse(txtPickupDate.Text, out dt) ? dt : dt; c.ReturnDate = DateTime.TryParse(txtReturnDate.Text, out dt) ? dt : dt; c.CarrierPickUpLastDate = DateTime.TryParse(txtCarrierPickup.Text, out dt) ? dt : dt; c.CustomerReturnLastDate = DateTime.TryParse(txtCustReturnLastFree.Text, out dt) ? dt : dt; c.CustomerPickupLastDate = DateTime.TryParse(txtCustPickupLastFree.Text, out dt) ? dt : dt; c.CarrierReturnLastDate = DateTime.TryParse(txtCarrierReturn.Text, out dt) ? dt : dt; c.Rate = txtRates.Text; if (grCargo.DataSource != null) { foreach (Obout.Grid.GridRow gr in grCargo.Rows) { bool inst = false; System.Collections.Hashtable row = gr.ToHashtable(); if (row.Count > 0) { BusinessObjects.ContainerCargo crg = (from cr in c.Cargo where cr.ID == int.Parse(row["ID"].ToString()) select cr).FirstOrDefault(); if (crg == null) { crg = new BusinessObjects.ContainerCargo(); inst = true; } int i; double d; bool b; i = 0; int.TryParse(row["ID"].ToString(), out i); crg.ID = i; crg.NetWeight = double.TryParse(row["NetWeight"].ToString(), out d) ? d : 0; //i = 1; int.TryParse(row["NetWeightUnit"].ToString(), out i); crg.NetWeightUnit = (BusinessObjects.Units.WeightUnits)i; i = 0; int.TryParse(row["Pieces"].ToString(), out i); crg.Pieces = i; crg.UOM = row["UOM"].ToString(); crg.Description = row["Description"].ToString(); d = 0; double.TryParse(row["GrossWeight"].ToString(), out d); crg.GrossWeight = d; //i = 1; int.TryParse(row["GrossWeightUnit"].ToString(), out i); crg.GrossWeightUnit = (BusinessObjects.Units.WeightUnits)i; crg.Hazardous = bool.TryParse(row["Hazardous"].ToString(), out b) ? b : false; if (inst) { c.Cargo.Add(crg); } } } } }