protected void GetPurchaseRequisitionProductListById(string purchaseRequisitionId)
{
PurchaseRequisitionBLL purchaseRequisition = new PurchaseRequisitionBLL();
try
{
DataTable dt = purchaseRequisition.GetPurchaseRequisitionProductListById(purchaseRequisitionId);
if (dt.Rows.Count > 0)
{
purchaseRequisitionProductListGridView.DataSource = dt;
purchaseRequisitionProductListGridView.DataBind();
if (purchaseRequisitionProductListGridView.Rows.Count > 0)
{
approveButton.Enabled = true;
purchaseRequisitionProductListGridView.UseAccessibleHeader = true;
purchaseRequisitionProductListGridView.HeaderRow.TableSection = TableRowSection.TableHeader;
TextBox approveQuantityTextBox;
TextBox unitPriceTextBox;
DropDownList vendorDropDownList;
VendorBLL vendor = new VendorBLL();
DataTable dtVendor=new DataTable();
for (int i = 0; i < purchaseRequisitionProductListGridView.Rows.Count; i++)
{
approveQuantityTextBox = (TextBox)purchaseRequisitionProductListGridView.Rows[i].FindControl("approveQuantityTextBox");
//approveQuantityTextBox.Text = purchaseRequisitionProductListGridView.Rows[i].Cells[3].Text.ToString();
approveQuantityTextBox.Text = dt.Rows[i][3].ToString();
unitPriceTextBox = (TextBox)purchaseRequisitionProductListGridView.Rows[i].FindControl("unitPriceTextBox");
unitPriceTextBox.Text = dt.Rows[i]["UnitPrice"].ToString();
dtVendor = vendor.GetProductVendorsByProductId(purchaseRequisitionProductListGridView.Rows[i].Cells[0].Text.ToString());
vendorDropDownList = (DropDownList)purchaseRequisitionProductListGridView.Rows[i].FindControl("vendorDropDownList");
vendorDropDownList.DataSource = dtVendor;
vendorDropDownList.DataValueField = "VendorId";
vendorDropDownList.DataTextField = "VendorName";
vendorDropDownList.DataBind();
vendorDropDownList.Items.Insert(0, "");
vendorDropDownList.SelectedIndex = 0;
vendorDropDownList.Items.Insert(dtVendor.Rows.Count+1, "Select Others.");
}
}
else
{
approveButton.Enabled = false;
}
}
else
{
msgbox.Visible = true; msgTitleLabel.Text = "Data Not Found!!!"; msgDetailLabel.Text = "";
}
}
catch (Exception ex)
{
msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = ex.Message;
}
finally
{
purchaseRequisition = null;
}
}
protected void productVendorButton_Click(object sender, EventArgs e)
{
ProductBLL product = new ProductBLL();
VendorBLL vendor = new VendorBLL();
try
{
DataTable dt = product.GetProductByBarcodeIdName(productTextBox.Text.Trim());
if (dt.Rows.Count > 0)
{
barcodeLabel.Text = dt.Rows[0]["Barcode"].ToString();
productIdLabel.Text = dt.Rows[0]["ProductId"].ToString();
productNameLabel.Text = dt.Rows[0]["ProductName"].ToString();
productGroupNameLabel.Text = dt.Rows[0]["ProductGroupName"].ToString();
productVendorListListBox.Items.Clear();
DataTable dtVendor = vendor.GetProductVendorsByProductId(productIdLabel.Text.Trim());
for (int i = 0; i < dtVendor.Rows.Count; i++)
{
productVendorListListBox.Items.Add(new ListItem(dtVendor.Rows[i]["VendorName"].ToString(), dtVendor.Rows[i]["VendorId"].ToString()));
}
productVendorPane.Visible = true;
}
else
{
productVendorPane.Visible = false;
msgbox.Visible = true; msgTitleLabel.Text = "Product Data Not Found!!!"; msgDetailLabel.Text = "";
msgbox.Attributes.Add("class", "alert alert-warning");
}
}
catch (Exception ex)
{
string message = ex.Message;
if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; }
MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");");
}
finally
{
product = null;
vendor = null;
countProductVendorLabel.Text = "Total: " + productVendorListListBox.Items.Count.ToString();
MyAlertBox("MyOverlayStop();");
}
}