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