void SetControlError(ref bool FirstError, TroposInput iControl)
{
iControl.HighlightError = true;
if (FirstError)
{
FirstError = false;
iControl.Focus();
}
}
void SetControlError(ref bool FirstError, TroposInput iControl, bool highlight)
{
iControl.HighlightError = highlight;
if (highlight)
{
if (FirstError)
{
FirstError = false;
iControl.Focus();
}
}
}
protected void tab_Clear_main_Click(object sender, CommandEventArgs e)
{
int i = Convert.ToInt32(e.CommandArgument);
TroposInput ReceivedQty = (TroposInput)grdGOODSIN.Rows[i].Cells[6].FindControl("iRECEIVEDQTY");
ReceivedQty.Text = string.Empty;
DropDownList UOM = (DropDownList)grdGOODSIN.Rows[i].Cells[7].FindControl("iUOM");
UOM.ClearSelection();
TroposInput AdviceNote = (TroposInput)grdGOODSIN.Rows[i].Cells[8].FindControl("iADVICENOTE");
AdviceNote.Text = string.Empty;
TroposBusinessCalendar ReceivedDate = (TroposBusinessCalendar)grdGOODSIN.Rows[i].Cells[10].FindControl("tbcRECEIVEDDATE");
ReceivedDate.Text = DateTime.Today.ToShortDateString();
ReceivedQty.HighlightError = false;
AdviceNote.HighlightError = false;
ShowMessage(string.Empty);
}
protected void tab_Clear_Click(object sender, EventArgs e)
{
for (int i = 0; i < grdGOODSIN.Rows.Count; i++)
{
try
{
TroposInput ReceivedQty = (TroposInput)grdGOODSIN.Rows[i].Cells[6].FindControl("iRECEIVEDQTY");
ReceivedQty.Text = string.Empty;
DropDownList UOM = (DropDownList)grdGOODSIN.Rows[i].Cells[7].FindControl("iUOM");
UOM.Text = string.Empty;
TroposInput AdviceNote = (TroposInput)grdGOODSIN.Rows[i].Cells[8].FindControl("iADVICENOTE");
AdviceNote.Text = string.Empty;
ReceivedQty.HighlightError = false;
AdviceNote.HighlightError = false;
ShowMessage(string.Empty);
}
catch (Exception)
{
// no error handling required
}
}
}
protected bool Validation(int index)
{
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();
// Entry Validation
float floatValidation;
int intValidation;
// RECEIVED QUANTITY / TROPOSINPUT - FLOAT
if (!float.TryParse(ReceivedQty.Text, out floatValidation))
{
ShowMessage("Received Quantity is not a number");
ReceivedQty.HighlightError = true;
return(false);
}
if (float.Parse(ReceivedQty.Text) == 0)
{
ShowMessage("Please enter valid, non-zero value for received quantity");
ReceivedQty.HighlightError = true;
return(false);
}
if (float.Parse(ReceivedQty.Text) < 0)
{
ShowMessage("Please enter a valid, non-zero value for received quantity");
ReceivedQty.HighlightError = true;
return(false);
}
// VALIDATION PASSED
ShowMessage(string.Empty);
ReceivedQty.HighlightError = false;
// ADVICE NOTE / TROPOSINPUT - NON BLANK
if (AdviceNote.Text.Trim() == string.Empty)
{
ShowMessage("Please enter an advice note");
AdviceNote.HighlightError = true;
return(false);
}
// VALIATION PASSED
ShowMessage(string.Empty);
AdviceNote.HighlightError = false;
// RECEIVED DATE - TROPOSBUSINESSCALENDAR / VALID DATE, NOT BLANK
DateTime datetime;
if (!DateTime.TryParse(ReceivedDate.Text, out datetime))
{
ShowMessage("Please enter a valid date");
ReceivedDate.HighlightError = true;
return(false);
}
//VALIDATION PASSED
ShowMessage(string.Empty);
ReceivedDate.HighlightError = false;
// STORE & LOCATION / DEFAULT FOR ITEM PULLED THROUGH FROM SQL QUERY (Populate_grdGOODSIN.cs) - MUST BE VALID STORE AND LOCATION COMBINATION
SLDY sldy = new SLDY();
sldy.iSTOR_SL = Store.Text;
sldy.iBINLOCN_SL = Location.Text;
if (!sldy.Execute(true))
{
ShowMessage("Please enter a valid Store and Location");
Store.HighlightError = true;
Location.HighlightError = true;
return(false);
}
// VALIDATION PASSED
ShowMessage(string.Empty);
Store.HighlightError = false;
Location.HighlightError = false;
// COUNTRY OF ORIGIN / DROPDOWN - NON BLANK
if (CountryOfOrigin.Text.Trim() == string.Empty)
{
ShowMessage("Please enter a country of origin");
CountryOfOrigin.BackColor = ColorTranslator.FromHtml("#ea542e");
CountryOfOrigin.ForeColor = Color.White;
return(false);
}
// VALIDATION PASSED
ShowMessage(string.Empty);
CountryOfOrigin.BackColor = Color.Transparent;
CountryOfOrigin.ForeColor = Color.Black;
// CONTAINER TYPE / DROPDOWN - NON BLANK
if (ContainerType.Text == string.Empty)
{
ShowMessage("Please select a container type");
ContainerType.BackColor = ColorTranslator.FromHtml("#ea542e");
ContainerType.ForeColor = Color.White;
return(false);
}
// VALIDATION PASSED
ShowMessage(string.Empty);
ContainerType.BackColor = Color.Transparent;
ContainerType.ForeColor = Color.Black;
// NUMBER OF CONTAINERS / TEXT FIELD - INTEGER
if (!int.TryParse(NumberOfContainers.Text, out intValidation))
{
ShowMessage("Please enter a valid, non-zero value for the number of containers");
NumberOfContainers.HighlightError = true;
return(false);
}
if (int.Parse(NumberOfContainers.Text) == 0)
{
ShowMessage("Please enter a valid, non-zero value for the number of containers");
NumberOfContainers.HighlightError = true;
return(false);
}
if (int.Parse(NumberOfContainers.Text) < 0)
{
ShowMessage("Please enter a valid, non-zero value for the number of containers");
NumberOfContainers.HighlightError = true;
return(false);
}
// VALIDATION PASSED
ShowMessage(string.Empty);
NumberOfContainers.HighlightError = false;
//PALLET TYPE - DROPDOWN - NON BLANK
if (PalletType.Text == string.Empty)
{
ShowMessage("Please select pallet type");
PalletType.BackColor = ColorTranslator.FromHtml("#ea542e");
PalletType.ForeColor = Color.White;
return(false);
}
// VALIDATION PASSED
ShowMessage(string.Empty);
PalletType.BackColor = Color.Transparent;
PalletType.ForeColor = Color.Black;
// NUMBER OF PALLETS / TEXT FIELD - INTEGER
if (!int.TryParse(NumberOfPallets.Text, out intValidation))
{
ShowMessage("Please enter a valid, non-zero value for number of pallets");
NumberOfPallets.HighlightError = true;
return(false);
}
if (int.Parse(NumberOfPallets.Text) <= 0)
{
ShowMessage("Please enter a valid, non-zero value for number of pallets");
NumberOfPallets.HighlightError = true;
return(false);
}
// VALIDATION PASSED
ShowMessage(string.Empty);
NumberOfPallets.HighlightError = false;
// ALL VALIDATION PASSED
return(true);
}
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);
}
