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