protected void btnSave_Click(object sender, EventArgs e) { IBOrderTrackingEntities oConection = new IBOrderTrackingEntities(); if (Session["SO"] != null) { string mSO = Session["SO"].ToString(); SOHeader oHeader = oConection.SOHeaders.SingleOrDefault(x => x.SO.Equals(mSO)); oHeader.PO = txtPO.Value; oHeader.DocAWB = txtDocAWB.Value; //oHeader.TTSlip = txtTTSlip. //if (!String.IsNullOrEmpty(txtTTSlip.Value)) //{ // var oDate = Nullable<DateTime>.Parse(txtTTSlip.Value); //} //if (!string.IsNullOrEmpty(txtTTSlip.Value)) //{ // DateTime?.Parse.txtTTSlip(); //} oConection.SaveChanges(); divSave.Attributes.Remove("hidden"); divSave.InnerText = "Save Success"; } }
protected void GetSOHeaderByID(string strSO) { IBOrderTrackingEntities oConnect = new IBOrderTrackingEntities(); SOHeader oHeader = oConnect.SOHeaders.SingleOrDefault(x => x.SO.Equals(strSO)); if (oHeader != null) { SetObjectValue(oHeader); } }
private void GenerateTable() { //Header //Add header to table TableRow oRow = new TableRow(); oRow.TableSection = TableRowSection.TableHeader; int noCol = 0; foreach (var item in getSOHeader()) { if (noCol < 9) { TableCell oH1 = new TableCell(); oH1.Text = item; oRow.Cells.Add(oH1); } noCol++; } //Finish Header tblData.Rows.Add(oRow); //Rows WebIBOST1.IBOrderTrackingEntities oConnect = new IBOrderTrackingEntities(); if (oConnect.SOHeaders.Count() > 0) { var soItem = oConnect.SOHeaders.ToList(); foreach (var row in soItem) { noCol = 0; //Add Detail to table TableRow oDetail = new TableRow(); oDetail.TableSection = TableRowSection.TableBody; Type oType = row.GetType(); PropertyInfo[] props = oType.GetProperties(); foreach (var prop in props) { //Row 1 Col 1 if (noCol < 9) { TableCell oR1 = new TableCell(); if (prop.Name == "SO") { oR1.Text = prop.GetValue(row) != null?SetLinkSOUrl(prop.GetValue(row).ToString()) : "'/>"; } else if (prop.Name == "PO") { oR1.Text = prop.GetValue(row) != null?SetLinkPOUrl(prop.GetValue(row).ToString()) : "'/>"; } else { oR1.Text = prop.GetValue(row) != null?prop.GetValue(row).ToString() : ""; } oDetail.Cells.Add(oR1); } noCol++; } // Finish 1 Row tblData.Rows.Add(oDetail); } // Add class tblData.Attributes.Add("class", "table table-striped table-bordered table-hover"); } }