public void FillCombo()
{
try
{
string COND = string.Empty;
//if (!Convert.ToBoolean(Session["IsCentral"].ToString()))
//{
// // COND = COND + " AND USD.FK_UserId=" + Convert.ToInt32(Session["UserID"].ToString());
//}
DS = Obj_RequisitionCafeteria.FillRequisitionNoComboForReport(Convert.ToInt32(Session["UserID"]), out StrError);
{
if (DS.Tables.Count > 0)
{
if (DS.Tables[0].Rows.Count > 0)
{
ddlRequisitionNo.DataSource = DS.Tables[0];
ddlRequisitionNo.DataTextField = "RequisitionNo";
ddlRequisitionNo.DataValueField = "RequisitionCafeId";
ddlRequisitionNo.DataBind();
}
if (DS.Tables[1].Rows.Count > 0)
{
ddlTemplateNo.DataSource = DS.Tables[1];
ddlTemplateNo.DataTextField = "Location";
ddlTemplateNo.DataValueField = "StockLocationID";
ddlTemplateNo.DataBind();
}
if (DS.Tables[4].Rows.Count > 0)
{
ddlEmployee.DataSource = DS.Tables[4];
ddlEmployee.DataTextField = "UserName";
ddlEmployee.DataValueField = "UserId";
ddlEmployee.DataBind();
}
}
else
{
DS = null;
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void FillCombo()
{
try
{
string COND = string.Empty;
//if (!Convert.ToBoolean(Session["IsCentral"].ToString()))
//{
// //COND = COND + " AND P.Loc=" + Convert.ToInt32(Session["CafeteriaId"].ToString());
//}
DS = Obj_RequisitionCafeteria.FillRequisitionNoComboForReport(Convert.ToInt32(Session["UserID"].ToString()), out StrError);
{
if (DS.Tables.Count > 0)
{
if (DS.Tables[0].Rows.Count > 0)
{
ddlRequisitionNo.DataSource = DS.Tables[0];
ddlRequisitionNo.DataTextField = "RequisitionNo";
ddlRequisitionNo.DataValueField = "RequisitionCafeId";
ddlRequisitionNo.DataBind();
}
if (DS.Tables[1].Rows.Count > 0)
{
ddlTemplateNo.DataSource = DS.Tables[1];
ddlTemplateNo.DataTextField = "Location";
ddlTemplateNo.DataValueField = "StockLocationID";
ddlTemplateNo.DataBind();
}
if (DS.Tables[2].Rows.Count > 0)
{
ddlItems.DataSource = DS.Tables[2];
ddlItems.DataTextField = "ItemName";
ddlItems.DataValueField = "ItemId";
ddlItems.DataBind();
}
if (DS.Tables[3].Rows.Count > 0)
{
ddlCategory.DataSource = DS.Tables[3];
ddlCategory.DataTextField = "CategoryName";
ddlCategory.DataValueField = "CategoryId";
ddlCategory.DataBind();
}
if (DS.Tables[4].Rows.Count > 0)
{
ddlEmployee.DataSource = DS.Tables[4];
ddlEmployee.DataTextField = "UserName";
ddlEmployee.DataValueField = "UserId";
ddlEmployee.DataBind();
}
if (DS.Tables[5].Rows.Count > 0)
{
ddlUnit.DataSource = DS.Tables[5];
ddlUnit.DataTextField = "Unit";
ddlUnit.DataValueField = "UnitId";
ddlUnit.DataBind();
}
if (DS.Tables[6].Rows.Count > 0)
{
ddlSize.DataSource = DS.Tables[6];
ddlSize.DataTextField = "SizeName";
ddlSize.DataValueField = "SizeId";
ddlSize.DataBind();
}
if (DS.Tables[7].Rows.Count > 0)
{
ddlSubCategory.DataSource = DS.Tables[7];
ddlSubCategory.DataTextField = "SubCategory";
ddlSubCategory.DataValueField = "SubCategoryId";
ddlSubCategory.DataBind();
}
}
else
{
DS = null;
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}