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
{
}
}
