protected void UpdateGoodsInTable() { // Get goods in table data ITroposQuery grdGOODSIN_Query = new Populate_grdGOODSIN(UserContext, iPURCHASE_ORDER.Text); DataTable grd_data_table = Helpers.TroposQuery(grdGOODSIN_Query, UserContext); grdGOODSIN.DataSource = grd_data_table; grdGOODSIN.DataBind(); for (int i = 0; i < grdGOODSIN.Rows.Count; i++) { TroposInput Store = (TroposInput)grdGOODSIN.Rows[i].FindControl("iSTORE"); Store.Text = grd_data_table.Rows[i]["STOR"].ToString(); TroposInput Location = (TroposInput)grdGOODSIN.Rows[i].FindControl("iLOCATION"); Location.Text = grd_data_table.Rows[i]["BINLOCN"].ToString(); } ITroposQuery countryoforigin = new Populate_davlCOUNTRYOFORIGIN(UserContext); String ddlName = "iCOUNTRYOFORIGIN"; PopulateDDLfromQuery(countryoforigin, ddlName); ITroposQuery containers = new Populate_davlCONTAINER(UserContext); ddlName = "iCONTAINERTYPE"; PopulateDDLfromQuery(containers, ddlName); ITroposQuery pallets = new Populate_davlPALLETS(UserContext); ddlName = "iPALLETTYPE"; PopulateDDLfromQuery(pallets, ddlName); if (tcboxINCLUDECOMPLETE.Checked == false) { for (int i = 0; i < grdGOODSIN.Rows.Count; i++) { int outstandingamount; try { outstandingamount = int.Parse(grdGOODSIN.Rows[i].Cells[4].InnerText().Replace("<center>", string.Empty).Replace("</center>", string.Empty).Split(' ')[0].Trim()); } catch { outstandingamount = 0; } if (outstandingamount < 1 && grdGOODSIN.Rows[i].Cells[0].Controls.Count > 0) { grdGOODSIN.Rows[i].Visible = false; } else { grdGOODSIN.Rows[i].Visible = true; } } } try { ArrayList rowsToClear = new ArrayList(); for (int i = 1; i < grdGOODSIN.Rows.Count; i++) { int j = i - 1; string PrevLineNo = grdGOODSIN.Rows[j].Cells[0].InnerText().Replace("<center>", string.Empty).Replace("</center>", string.Empty).Trim(); string CurrentLineNo = grdGOODSIN.Rows[i].Cells[0].InnerText().Replace("<center>", string.Empty).Replace("</center>", string.Empty).Trim(); if (CurrentLineNo == PrevLineNo) { rowsToClear.Add(i); } } foreach (int row in rowsToClear) { grdGOODSIN.Rows[row].Cells[0].Controls.Clear(); grdGOODSIN.Rows[row].Cells[1].Controls.Clear(); grdGOODSIN.Rows[row].Cells[2].Controls.Clear(); grdGOODSIN.Rows[row].Cells[3].Controls.Clear(); grdGOODSIN.Rows[row].Cells[4].Controls.Clear(); grdGOODSIN.Rows[row].Cells[5].Controls.Clear(); grdGOODSIN.Rows[row].Cells[6].Controls.Clear(); grdGOODSIN.Rows[row].Cells[7].Controls.Clear(); grdGOODSIN.Rows[row].Cells[8].Controls.Clear(); grdGOODSIN.Rows[row].Cells[9].Controls.Clear(); grdGOODSIN.Rows[row].Cells[10].Controls.Clear(); grdGOODSIN.Rows[row].Cells[11].Controls.Clear(); grdGOODSIN.Rows[row].Cells[12].Controls.Clear(); grdGOODSIN.Rows[row].Cells[13].Controls.Clear(); grdGOODSIN.Rows[row].Cells[14].Controls.Clear(); grdGOODSIN.Rows[row].Cells[13].Controls.Clear(); grdGOODSIN.Rows[row].Cells[17].Controls.Clear(); grdGOODSIN.Rows[row].Cells[18].Controls.Clear(); } if (tcboxINCLUDECOMPLETE.Checked == false) { for (int i = 0; i < grdGOODSIN.Rows.Count; i++) { int outstandingamount; try { outstandingamount = int.Parse(grdGOODSIN.Rows[i].Cells[4].InnerText().Replace("<center>", string.Empty).Replace("</center>", string.Empty).Split(' ')[0].Trim()); } catch { outstandingamount = 0; } if (outstandingamount < 1 && grdGOODSIN.Rows[i].Cells[0].Controls.Count > 0) { grdGOODSIN.Rows[i].Visible = false; } else { grdGOODSIN.Rows[i].Visible = true; } } } // remove special case where all received <= 0 and where there are multiple rows with same line number. Blank line numbers would still display otherwise. for (int i = 1; i < grdGOODSIN.Rows.Count; i++) { if (grdGOODSIN.Rows[i].Cells[0].Controls.Count == 0 && tcboxINCLUDECOMPLETE.Checked == false) { grdGOODSIN.Rows[i].Visible = false; } } } catch (Exception) { // do nothing here } }
public void imgEXECUTE_BTN_Command(object sender, CommandEventArgs e) { for (int i = 0; i < grdGOODSIN.Rows.Count; i++) { try { // Put data entry in gridview into viewstate TroposInput receivedQty = (TroposInput)grdGOODSIN.Rows[i].Cells[5].FindControl("iRECEIVEDQTY"); ViewState["receivedQty_" + i.ToString()] = receivedQty.Text; TroposInput adviceNote = (TroposInput)grdGOODSIN.Rows[i].Cells[6].FindControl("iADVICENOTE"); ViewState["adviceNote_" + i.ToString()] = adviceNote.Text; TroposBusinessCalendar receivedDate = (TroposBusinessCalendar)grdGOODSIN.Rows[i].Cells[7].FindControl("iRECEIVEDDATE"); ViewState["receivedDate_" + i.ToString()] = receivedDate.Text; TroposInput store = (TroposInput)grdGOODSIN.Rows[i].Cells[8].FindControl("iSTORE"); ViewState["store_" + i.ToString()] = store.Text; TroposInput location = (TroposInput)grdGOODSIN.Rows[i].Cells[9].FindControl("iLOCATION"); ViewState["location_" + i.ToString()] = location.Text; DropDownList countryOfOrigin = (DropDownList)grdGOODSIN.Rows[i].Cells[10].FindControl("iCOUNTRYOFORIGIN"); ViewState["countryOfOrigin_" + i.ToString()] = countryOfOrigin.Text; DropDownList containerType = (DropDownList)grdGOODSIN.Rows[i].Cells[11].FindControl("iCONTAINERTYPE"); ViewState["containerType_" + i.ToString()] = containerType.Text; TroposInput numberOfContainers = (TroposInput)grdGOODSIN.Rows[i].Cells[12].FindControl("iNUMBEROFCONTAINERS"); ViewState["numberOfContainers_" + i.ToString()] = numberOfContainers.Text; DropDownList palletType = (DropDownList)grdGOODSIN.Rows[i].Cells[13].FindControl("iPALLETTYPE"); ViewState["palletType_" + i.ToString()] = palletType.Text; TroposInput numberOfPallets = (TroposInput)grdGOODSIN.Rows[i].Cells[14].FindControl("iNUMBEROFPALLETS"); ViewState["numberOfPallets_" + i.ToString()] = numberOfPallets.Text; } catch (Exception) { // no exception } } // e.command arguement is the row index to be written to file. Get data from input fields and validate int index = Convert.ToInt32(e.CommandArgument); ViewState["purchaseOrder"] = iPURCHASE_ORDER.Text; TroposInput ReceivedQty = (TroposInput)grdGOODSIN.Rows[index].Cells[5].FindControl("iRECEIVEDQTY"); TroposInput AdviceNote = (TroposInput)grdGOODSIN.Rows[index].Cells[6].FindControl("iADVICENOTE"); TroposBusinessCalendar ReceivedDate = (TroposBusinessCalendar)grdGOODSIN.Rows[index].Cells[7].FindControl("tbcRECEIVEDDATE"); TroposInput Store = (TroposInput)grdGOODSIN.Rows[index].Cells[8].FindControl("iSTORE"); TroposInput Location = (TroposInput)grdGOODSIN.Rows[index].Cells[9].FindControl("iLOCATION"); DropDownList CountryOfOrigin = (DropDownList)grdGOODSIN.Rows[index].Cells[10].FindControl("iCOUNTRYOFORIGIN"); DropDownList ContainerType = (DropDownList)grdGOODSIN.Rows[index].Cells[11].FindControl("iCONTAINERTYPE"); TroposInput NumberOfContainers = (TroposInput)grdGOODSIN.Rows[index].Cells[12].FindControl("iNUMBEROFCONTAINERS"); DropDownList PalletType = (DropDownList)grdGOODSIN.Rows[index].Cells[13].FindControl("iPALLETTYPE"); TroposInput NumberOfPallets = (TroposInput)grdGOODSIN.Rows[index].Cells[14].FindControl("iNUMBEROFPALLETS"); ViewState["LineNo"] = grdGOODSIN.Rows[index].Cells[0].InnerText().Replace("<center>", string.Empty).Replace("</center>", string.Empty).Trim(); if (!Validation(index)) { return; } ViewState["receivedquantity"] = ReceivedQty.Text; ViewState["advicenote"] = AdviceNote.Text; ViewState["receivedDate"] = ReceivedDate.Text; ViewState["store"] = Store.Text; ViewState["location"] = Location.Text; ViewState["countryoforigin"] = CountryOfOrigin.Text; ViewState["containertype"] = ContainerType.Text; ViewState["numberofcontainers"] = NumberOfContainers.Text; ViewState["pallettype"] = PalletType.Text; ViewState["numberofpallets"] = NumberOfPallets.Text; TransAlert.Visible = true; updConfirm.Update(); // Refresh Grid Details ITroposQuery grdGOODSIN_Query = new Populate_grdGOODSIN(UserContext, iPURCHASE_ORDER.Text); DataTable grd_data_table = Helpers.TroposQuery(grdGOODSIN_Query, UserContext); grdGOODSIN.DataSource = grd_data_table; grdGOODSIN.DataBind(); for (int i = 0; i < grdGOODSIN.Rows.Count; i++) { try { ReceivedQty = (TroposInput)grdGOODSIN.Rows[i].Cells[5].FindControl("iRECEIVEDQTY"); ReceivedQty.Text = ViewState["receivedQty_" + i.ToString()].ToString(); AdviceNote = (TroposInput)grdGOODSIN.Rows[i].Cells[6].FindControl("iADVICENOTE"); AdviceNote.Text = ViewState["adviceNote_" + i.ToString()].ToString(); ReceivedDate = (TroposBusinessCalendar)grdGOODSIN.Rows[i].Cells[7].FindControl("tbcRECEIVEDDATE"); ReceivedDate.Text = ViewState["receivedDate_" + i.ToString()].ToString(); Store = (TroposInput)grdGOODSIN.Rows[i].Cells[8].FindControl("iSTORE"); Store.Text = ViewState["store_" + i.ToString()].ToString(); Location = (TroposInput)grdGOODSIN.Rows[i].Cells[9].FindControl("iLOCATION"); Location.Text = ViewState["location_" + i.ToString()].ToString(); CountryOfOrigin = (DropDownList)grdGOODSIN.Rows[i].Cells[10].FindControl("iCOUNTRYOFORIGIN"); CountryOfOrigin.Text = ViewState["countryOfOrigin_" + i.ToString()].ToString(); ContainerType = (DropDownList)grdGOODSIN.Rows[i].Cells[11].FindControl("iCONTAINERTYPE"); ContainerType.Text = ViewState["containerType_" + i.ToString()].ToString(); NumberOfContainers = (TroposInput)grdGOODSIN.Rows[i].Cells[12].FindControl("iNUMBEROFCONTAINERS"); NumberOfContainers.Text = ViewState["numberOfContainers_" + i.ToString()].ToString(); PalletType = (DropDownList)grdGOODSIN.Rows[i].Cells[13].FindControl("iPALLETTYPE"); PalletType.Text = ViewState["palletType_" + i.ToString()].ToString(); NumberOfPallets = (TroposInput)grdGOODSIN.Rows[i].Cells[14].FindControl("iNUMBEROFPALLETS"); NumberOfPallets.Text = ViewState["numberOfPallets_" + i.ToString()].ToString(); } catch (Exception) { // no error handling implemented } } ReceivedQty.HighlightError = false; AdviceNote.HighlightError = false; ReceivedDate.HighlightError = false; Store.HighlightError = false; Location.HighlightError = false; NumberOfContainers.HighlightError = false; NumberOfPallets.HighlightError = false; ShowMessage(string.Empty); }