private void GetSticker(string assetCode)
{
Hashtable ht = new Hashtable();
ht.Add("RegionCode", "");
ht.Add("OfficeCode", "");
ht.Add("DepartmentCode", "");
ht.Add("UserId", "");
ht.Add("GroupCode", "");
ht.Add("AssetCode", assetCode);
ht.Add("Type", "ByIndividualItem");
ht.Add("OCode", "8989");
DataSet ds = new DataSet();
ds = ReportsBll.AssetStickers(ht);
DataTable data = ds.Tables[0];
DataTable dtCompany = ds.Tables[1];
List <Sticker> stickers = new List <Sticker>();
foreach (DataRow dr in data.Rows)
{
Sticker s = new Sticker();
s.AssetCode = dr["AssetCode"].ToString();
s.AssetName = dr["AssetName"].ToString();
byte[] bcode = imageToByteArray(GiveBarcode(dr["AssetCode"].ToString()));
s.Barcode = bcode;
s.CompanyName = dr["CompanyName"].ToString();
stickers.Add(s);
}
BindReport(stickers, dtCompany);
}
protected void btnGenerateReport_Click(object sender, EventArgs e)
{
try
{
string Category = rdoBy.SelectedValue;
//if (Category == "ByGroup")
//{
Hashtable ht = new Hashtable();
ht.Add("RegionCode", ddlRegion.SelectedValue);
ht.Add("OfficeCode", ddlOffice.SelectedValue);
ht.Add("DepartmentCode", ddlDepartment.SelectedValue);
ht.Add("UserId", "");
ht.Add("GroupCode", ddlGroup.SelectedValue);
ht.Add("AssetCode", txtAssetCode.Text);
ht.Add("Type", Category);
ht.Add("OCode", ((SessionUser)base.Session["SessionUser"]).OCode);
//ht.Add("OCode", "8989");
DataSet ds = new DataSet();
ds = ReportsBll.AssetStickers(ht);
DataTable data = ds.Tables[0];
DataTable dtCompany = ds.Tables[1];
List <Sticker> stickers = new List <Sticker>();
foreach (DataRow dr in data.Rows)
{
Sticker s = new Sticker();
s.AssetCode = dr["AssetCode"].ToString();
s.AssetName = dr["AssetName"].ToString();
byte[] bcode = imageToByteArray(GiveBarcode(dr["AssetCode"].ToString()));
s.Barcode = bcode;
s.CompanyName = dr["CompanyName"].ToString();
stickers.Add(s);
}
BindReport(stickers, dtCompany);
//}
}
catch
{
}
}
