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); }
// private void GetTransferVoucherReport(int TotalNumberofAssets, string TransferNo, DateTime TransferDate, string FromRegion, string ToRegion, string ToOffice, string ToDepartment, string ToUser) { ReportsBll ReportBll = new ReportsBll(); Hashtable ht = new Hashtable(); ht.Add("TransferNo", TransferNo); //ht.Add("OCode", "8989"); ht.Add("OCode", ((SessionUser)base.Session["SessionUser"]).OCode); DataSet transferVoucher = new DataSet(); transferVoucher = ReportBll.GetTransferVoucher(ht); DataTable data = transferVoucher.Tables[0]; DataTable dtCompany = transferVoucher.Tables[1]; this.BindReport(TotalNumberofAssets, data, TransferDate, dtCompany, TransferNo, FromRegion, ToRegion, ToOffice, ToDepartment, ToUser); }
protected void BtnSave_Click(object sender, EventArgs e) { try { string SummaryOrIndivudual = RadioButtonList1.SelectedValue; if (SummaryOrIndivudual == "IndividualItem") { string AsPer = rdoAsPer.SelectedValue; Hashtable ht = new Hashtable(); ht.Add("DateFrom", txtDateFrom.Text); ht.Add("DateTo", txtDateTo.Text); ht.Add("AssetCode", txtAssetCode.Text); ht.Add("AsPer", rdoAsPer.SelectedValue); ht.Add("OCode", ((SessionUser)base.Session["SessionUser"]).OCode); //ht.Add("OCode", "8989"); DataTable dt = new DataTable(); DataSet ds = new DataSet(); ds = ReportsBll.AssetRegister(ht, SummaryOrIndivudual); DataTable data = ds.Tables[0]; DataTable dtCompany = ds.Tables[1]; BindReport(dtCompany, data, AsPer, RadioButtonList1.SelectedValue); } else if (SummaryOrIndivudual == "Summary") { string AsPer = rdoAsPer.SelectedValue; Hashtable ht = new Hashtable(); ht.Add("DateFrom", txtDateFrom.Text); ht.Add("DateTo", txtDateTo.Text); ht.Add("AsPer", rdoAsPer.SelectedValue); ht.Add("OCode", ((SessionUser)base.Session["SessionUser"]).OCode); //ht.Add("OCode", "8989"); DataTable dt = new DataTable(); DataSet ds = new DataSet(); ds = ReportsBll.AssetRegister(ht, SummaryOrIndivudual); DataTable data = ds.Tables[0]; DataTable dtCompany = ds.Tables[1]; BindReport(dtCompany, data, AsPer, SummaryOrIndivudual); } } catch { } }
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 { } }
protected void btnGenerateReport_Click(object sender, EventArgs e) { try { string selectedValue = this.rdoBy.SelectedValue; Hashtable ht = new Hashtable(); ht.Add("DateFrom", this.txtDateFrom.Text); ht.Add("DateTo", this.txtDateTo.Text); ht.Add("Type", selectedValue); ht.Add("AssetCode", this.txtAssetCode.Text); ht.Add("OCode", ((SessionUser)base.Session["SessionUser"]).OCode); //ht.Add("OCode", "8989"); DataSet set = new DataSet(); set = ReportsBll.OverallAccountingEntry(ht); DataTable data = set.Tables[0]; DataTable dtCompany = set.Tables[1]; this.BindReport(data, dtCompany); } catch { } }
protected void BtnSave_Click(object sender, EventArgs e) { try { string AsPer = rdoAsPer.SelectedValue; Hashtable ht = new Hashtable(); ht.Add("DateFrom", txtDateFrom.Text); ht.Add("DateTo", txtDateTo.Text); ht.Add("AsPer", rdoAsPer.SelectedValue); ht.Add("OCode", ((SessionUser)base.Session["SessionUser"]).OCode); //ht.Add("OCode", "8989"); DataTable dt = new DataTable(); DataSet ds = new DataSet(); ds = ReportsBll.AssetSchedule(ht); DataTable data = ds.Tables[0]; DataTable dtCompany = ds.Tables[1]; BindReport(dtCompany, data, AsPer); } catch { } }