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