public void ProcessRequest(HttpContext context)
{
var id = context.Request.QueryString["id"];
// LumexDBPlayer db = LumexDBPlayer.Start();
DataTable dt = new DataTable();
ProductBLL product = new ProductBLL();
dt = product.GetAllProductsBySalesCenter(id);
StringBuilder sb = new StringBuilder();
for (int i = 0; i < dt.Rows.Count; i++)
{
string employee = dt.Rows[i]["ProductId"].ToString()+"["+ dt.Rows[i]["ProductName"].ToString()+"]" + ";";
sb.Append(employee).Append(Environment.NewLine);
}
context.Response.Write(sb.ToString());
}
protected void GetAvailableProductListBySalesCenter()
{
ProductBLL product = new ProductBLL();
try
{
DataTable dt = new DataTable();
product.WareHouseId = ddlSelectWareHouseOrSalesCenter.SelectedValue;
if (ddlSelectWareHouseOrSalesCenter.SelectedValue == "WH-002")
{
dt = product.GetMainProductsByWareHouseForSales();
saveButton.Text = "CREATE NEW SALES";
}
else
{
dt = product.GetAllProductsBySalesCenter(ddlSelectWareHouseOrSalesCenter.SelectedValue);
saveButton.Text = "CREATE NEW SALES";
}
if (dt.Rows.Count > 0)
{
productListGridView.DataSource = dt;
productListGridView.DataBind();
}
else
{
productListGridView.DataSource = dt;
productListGridView.DataBind();
}
if (productListGridView.Rows.Count > 0)
{
productListGridView.UseAccessibleHeader = true;
productListGridView.HeaderRow.TableSection = TableRowSection.TableHeader;
}
if (dt.Rows.Count < 1)
{
msgbox.Visible = true; msgTitleLabel.Text = "Products are not available for the selected Sales Center!!!"; msgDetailLabel.Text = "";
}
}
catch (Exception ex)
{
string message = ex.Message;
if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; }
MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");");
}
finally
{
product = null;
}
}