protected void GrdRegistration_RowDataBound(object sender, GridViewRowEventArgs e) { Organisation org = null; if (IsValidFormID()) { org = OrganisationDB.GetByID(GetFormID()); } DataTable dt = Session["registerstocktoorg_data"] as DataTable; bool tblEmpty = (dt.Rows.Count == 1 && dt.Rows[0][0] == DBNull.Value); if (!tblEmpty && e.Row.RowType == DataControlRowType.DataRow) { Label lblId = (Label)e.Row.FindControl("lblId"); DataRow[] foundRows = dt.Select("s_stock_id=" + lblId.Text); DataRow thisRow = foundRows[0]; DropDownList ddlOffering = (DropDownList)e.Row.FindControl("ddlOffering"); if (ddlOffering != null) { Offering[] incList_orig = StockDB.GetOfferingsByOrg(Convert.ToInt32(thisRow["organisation_id"])); Offering[] incList = Offering.RemoveByID(incList_orig, Convert.ToInt32(thisRow["o_offering_id"])); DataTable offering = OfferingDB.GetDataTable_AllNotInc(incList); offering.DefaultView.Sort = "o_name ASC"; foreach (DataRowView row in offering.DefaultView) { if (Convert.ToInt32(row["o_offering_id"]) == Convert.ToInt32(thisRow["o_offering_id"]) || Convert.ToInt32(row["o_offering_type_id"]) == 89) // only products, or other if was product when added but now not a product { ddlOffering.Items.Add(new ListItem(row["o_name"].ToString(), row["o_offering_id"].ToString())); } } ddlOffering.SelectedValue = thisRow["o_offering_id"].ToString(); } DropDownList ddlQuantity_Zeros = (DropDownList)e.Row.FindControl("ddlQuantity_Zeros"); DropDownList ddlQuantity_Tens = (DropDownList)e.Row.FindControl("ddlQuantity_Tens"); DropDownList ddlQuantity_Hundreds = (DropDownList)e.Row.FindControl("ddlQuantity_Hundreds"); if (ddlQuantity_Zeros != null && ddlQuantity_Tens != null && ddlQuantity_Hundreds != null) { for (int i = 0; i < 10; i++) { ddlQuantity_Zeros.Items.Add(new ListItem(i.ToString(), i.ToString())); ddlQuantity_Tens.Items.Add(new ListItem(i.ToString(), i.ToString())); ddlQuantity_Hundreds.Items.Add(new ListItem(i.ToString(), i.ToString())); } int qty = Convert.ToInt32(thisRow["s_qty"]); ddlQuantity_Zeros.SelectedValue = ((qty % 10) / 1).ToString(); ddlQuantity_Tens.SelectedValue = ((qty % 100) / 10).ToString(); ddlQuantity_Hundreds.SelectedValue = ((qty % 1000) / 100).ToString(); } DropDownList ddlWarningAmount = (DropDownList)e.Row.FindControl("ddlWarningAmount"); if (ddlWarningAmount != null) { ddlWarningAmount.Items.Add(new ListItem("No Warning", "-1")); for (int i = 0; i <= 50; i++) { ddlWarningAmount.Items.Add(new ListItem(i.ToString(), i.ToString())); } ddlWarningAmount.SelectedValue = thisRow["s_warning_amt"].ToString(); } Label lblWarningAmount = (Label)e.Row.FindControl("lblWarningAmount"); if (lblWarningAmount != null) { if (lblWarningAmount.Text == "-1") { lblWarningAmount.Text = "No Warning"; } } Utilities.AddConfirmationBox(e); if ((e.Row.RowState & DataControlRowState.Edit) > 0) { Utilities.SetEditRowBackColour(e, System.Drawing.Color.LightGoldenrodYellow); } } if (org != null && e.Row.RowType == DataControlRowType.Footer) { Label lblOrganisation = (Label)e.Row.FindControl("lblNewOrganisation"); if (lblOrganisation != null) { lblOrganisation.Text = org.Name; } DropDownList ddlOffering = (DropDownList)e.Row.FindControl("ddlNewOffering"); if (ddlOffering != null) { Offering[] incList = StockDB.GetOfferingsByOrg(org.OrganisationID); DataTable offering = OfferingDB.GetDataTable_AllNotInc(incList); offering.DefaultView.Sort = "o_name ASC"; foreach (DataRowView row in offering.DefaultView) { if (Convert.ToInt32(row["o_offering_type_id"]) == 89) // only products { ddlOffering.Items.Add(new ListItem(row["o_name"].ToString(), row["o_offering_id"].ToString())); } } if (offering.Rows.Count == 0) { hideFotter = true; } } DropDownList ddlQuantity_Zeros = (DropDownList)e.Row.FindControl("ddlNewQuantity_Zeros"); DropDownList ddlQuantity_Tens = (DropDownList)e.Row.FindControl("ddlNewQuantity_Tens"); DropDownList ddlQuantity_Hundreds = (DropDownList)e.Row.FindControl("ddlNewQuantity_Hundreds"); if (ddlQuantity_Zeros != null && ddlQuantity_Tens != null && ddlQuantity_Hundreds != null) { for (int i = 0; i < 10; i++) { ddlQuantity_Zeros.Items.Add(new ListItem(i.ToString(), i.ToString())); ddlQuantity_Tens.Items.Add(new ListItem(i.ToString(), i.ToString())); ddlQuantity_Hundreds.Items.Add(new ListItem(i.ToString(), i.ToString())); } } DropDownList ddlWarningAmount = (DropDownList)e.Row.FindControl("ddlNewWarningAmount"); if (ddlWarningAmount != null) { ddlWarningAmount.Items.Add(new ListItem("No Warning", "-1")); for (int i = 0; i <= 50; i++) { ddlWarningAmount.Items.Add(new ListItem(i.ToString(), i.ToString())); } } } }