protected void LoadReportCatBrand(object sender, EventArgs e)
{
string Type = Request.QueryString["Type"].ToString();
if (Type == "Stock-Summary")
{
string rptName = "StockWareHouseMaster.rpt";
SqlConnection Con = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
SqlParameter AccountsID = new SqlParameter("@CatID", ddlCategory.SelectedValue);
SqlParameter BrandID = new SqlParameter("@BrandID", ddlBrand.SelectedValue);
DataSet ds = AACommon.ReturnDatasetBySPForREPORT("STOCK_BALANCE_WH_MASTER_CAT_BRAND", "VW_STOCK_BALANCE_WH_MASTER", Con, AccountsID, BrandID);
Session["RptDS"] = ds;
Response.Redirect("~/Reports/Viewer.aspx?name=" + rptName + "&no=0&RptTable=VW_STOCK_BALANCE_WH_MASTER");
}
else
if (Type == "Stock-Ledger")
{
string rptName = "StockLedgerWareHouseMaster.rpt";
SqlConnection Con = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
SqlParameter AccountsID = new SqlParameter("@CatID", ddlCategory.SelectedValue);
SqlParameter BrandID = new SqlParameter("@BrandID", ddlBrand.SelectedValue);
DataSet ds = AACommon.ReturnDatasetBySPForREPORT("STOCK_LEDGER_WH_Master_CAT_BRAND", "VW_STOCK_LEDGER_WH_Master", Con, AccountsID, BrandID);
Session["RptDS"] = ds;
Response.Redirect("~/Reports/Viewer.aspx?name=" + rptName + "&no=0&RptTable=VW_STOCK_LEDGER_WH_Master");
}
}
protected void LoadReportBrand(object sender, EventArgs e)
{
var BranchID = "";
var UTDesc = "";
string Type = Request.QueryString["Type"].ToString();
if (Request.Cookies["BranchID"] != null)
{
BranchID = Request.Cookies["BranchID"].Value;
}
if (Request.Cookies["UTDesc"] != null)
{
UTDesc = Request.Cookies["UTDesc"].Value;
}
if (Type == "Stock-Summary")
{
string rptName = "Stock.rpt";
SqlConnection Con = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
SqlParameter AccountsID = new SqlParameter("@BrandID", ddlBrand.SelectedValue);
SqlParameter Branch = new SqlParameter("@BranchID", BranchID);
DataSet ds = AACommon.ReturnDatasetBySPForREPORT("STOCK_BALANCE_BRAND", "VW_STOCK_BALANCE", Con, AccountsID, Branch);
if (UTDesc == "Sales")
{
for (int intCount = 0; intCount < ds.Tables[0].Rows.Count; intCount++)
{
ds.Tables[0].Rows[intCount]["UnitPrice"] = "0";
ds.Tables[0].Rows[intCount]["UnitPriceOld"] = "0";
}
ds.Tables[0].AcceptChanges();
}
Session["RptDS"] = ds;
Response.Redirect("~/Reports/Viewer.aspx?name=" + rptName + "&no=0&RptTable=VW_STOCK_BALANCE");
}
else
if (Type == "Stock-Ledger")
{
string rptName = "StockLedger.rpt";
SqlConnection Con = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
SqlParameter AccountsID = new SqlParameter("@BrandID", ddlBrand.SelectedValue);
SqlParameter Branch = new SqlParameter("@BranchID", BranchID);
DataSet ds = AACommon.ReturnDatasetBySPForREPORT("STOCK_LEDGER_BRAND", "VW_STOCK_LEDGER", Con, AccountsID, Branch);
if (UTDesc == "Sales")
{
for (int intCount = 0; intCount < ds.Tables[0].Rows.Count; intCount++)
{
ds.Tables[0].Rows[intCount]["UnitPrice"] = "0";
ds.Tables[0].Rows[intCount]["TotalPrice"] = "0";
}
ds.Tables[0].AcceptChanges();
}
Session["RptDS"] = ds;
Response.Redirect("~/Reports/Viewer.aspx?name=" + rptName + "&no=0&RptTable=VW_STOCK_LEDGER");
}
}
protected void LoadReport(object sender, EventArgs e)
{
string starttime = " 00:00:00.000";
string endtime = " 23:59:00.000";
string rptName = "ControlReport.rpt";
var BranchID = "";
if (Request.Cookies["BranchID"] != null)
{
BranchID = Request.Cookies["BranchID"].Value;
}
SqlConnection Con = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
SqlParameter AccountsID = new SqlParameter("@ControlAccID", ddlCategory.SelectedValue);
SqlParameter Branch = new SqlParameter("@BranchID", BranchID);
SqlParameter DateFrom = new SqlParameter("@StartDate", StartDate.Value + starttime);
SqlParameter DateEnd = new SqlParameter("@EndDate", EndDate.Value + endtime);
DataSet ds = AACommon.ReturnDatasetBySPForREPORT("CONTROL_ACC_BALANCE", "VW_CONTROL_ACC_BALANCE", Con, AccountsID, Branch, DateFrom, DateEnd);
string query = "";
if (ds.Tables[0].Rows.Count > 0)
{
query = "select * from Accounts where ControlAccID='" + ddlCategory.SelectedValue + "'";
SqlDataAdapter da = new SqlDataAdapter(query, Con);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
string quersum = "select cast(ISNULL(sum(DebitPKR) - Sum(CreditPKR),0) as NUMERIC(15,2)) from Transaction_Detail where AccountID = '" + dt.Rows[i]["AccountsID"].ToString() + "' and Date < '" + StartDate.Value + "' and IsDelete=0";
SqlDataAdapter dda = new SqlDataAdapter(quersum, Con);
DataTable dtt = new DataTable();
dda.Fill(dtt);
if (dtt.Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Select("AccountsID = '" + dt.Rows[i]["AccountsID"].ToString() + "'"))
{
string d = Convert.ToString(Convert.ToDecimal(row[9]));
string ee = Convert.ToString(dtt.Rows[0][0].ToString());
row[9] = Convert.ToString(Convert.ToDecimal(row[9]) + Convert.ToDecimal(dtt.Rows[0][0].ToString()));
//row[9] = Convert.ToString(Convert.ToDecimal(row[9]));
row[10] = Convert.ToString(StartDate.Value);
row[11] = Convert.ToString(EndDate.Value);
}
ds.Tables[0].AcceptChanges();
}
}
}
}
Session["RptDS"] = ds;
Response.Redirect("~/Reports/Viewer.aspx?name=" + rptName + "&no=0&RptTable=VW_CONTROL_ACC_BALANCE");
}
protected void Page_Load(object sender, EventArgs e)
{
// string rqID = Request.QueryString["ID"].ToString();
string rptName = "Ledger.rpt";
SqlConnection Con = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
DataSet ds = AACommon.ReturnDatasetBySPForREPORT("LedgerReport", "VW_LEDGER", Con, null);
Session["RptDS"] = ds;
Response.Redirect("~/Reports/Viewer.aspx?name=" + rptName + "&no=0&RptTable=VW_LEDGER");
}
protected void Page_Load(object sender, EventArgs e)
{
// string rqID = Request.QueryString["ID"].ToString();
string rptName = "InComeStatement.rpt";
SqlConnection Con = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
//SqlParameter AccountsID = new SqlParameter("@AccountsID", ddlITEM.SelectedValue);
DataSet ds = AACommon.ReturnDatasetBySPForREPORT("INCOME_STATEMENT", "VW_INCOME_STATEMENT_DETAIL", Con, null);
Session["RptDS"] = ds;
Response.Redirect("~/Reports/Viewer.aspx?name=" + rptName + "&no=0&RptTable=VW_INCOME_STATEMENT_DETAIL");
}
protected void Page_Load(object sender, EventArgs e)
{
string rqID = Request.QueryString["ID"].ToString();
string rptName = "TR_OUT_HIS.rpt";
SqlConnection Con = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
SqlParameter ReqID = new SqlParameter("@WRIDMaster", rqID);
DataSet ds = AACommon.ReturnDatasetBySPForREPORT("TransferOrderMasterOUT_Print", "vwTransferOrderMasterOUT_Print", Con, ReqID);
Session["RptDS"] = ds;
Response.Redirect("~/Reports/Viewer.aspx?name=" + rptName + "&no=0&RptTable=vwTransferOrderMasterOUT_Print");
}
protected void LoadReport(object sender, EventArgs e)
{
// string rqID = Request.QueryString["ID"].ToString();
string rptName = "InComeStatement.rpt";
SqlConnection Con = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
SqlParameter DateFrom = new SqlParameter("@DateFrom", StartDate.Value);
SqlParameter DateEnd = new SqlParameter("@DateEnd", EndDate.Value);
DataSet ds = AACommon.ReturnDatasetBySPForREPORT("INCOME_STATEMENT_DATE_WISE", "VW_INCOME_STATEMENT_DETAIL", Con, DateFrom, DateEnd);
Session["RptDS"] = ds;
Response.Redirect("~/Reports/Viewer.aspx?name=" + rptName + "&no=0&RptTable=VW_INCOME_STATEMENT_DETAIL");
}
protected void Page_Load(object sender, EventArgs e)
{
string rqID = Request.QueryString["ID"].ToString();
string BID = Request.QueryString["BID"].ToString();
string rptName = "SO_His.rpt";
SqlConnection Con = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
SqlParameter ReqID = new SqlParameter("@SPID", rqID);
SqlParameter Branch = new SqlParameter("@BranchID", BID);
DataSet ds = AACommon.ReturnDatasetBySPForREPORT("SaleOrderPrint", "vwSaleOrderPRINT", Con, ReqID, Branch);
Session["RptDS"] = ds;
Response.Redirect("~/Reports/Viewer.aspx?name=" + rptName + "&no=0&RptTable=vwSaleOrderPRINT");
}
protected void Page_Load(object sender, EventArgs e)
{
// string rqID = Request.QueryString["ID"].ToString();
var BranchID = "";
BranchID = Request.Cookies["BranchID"].Value;
string rptName = "BarCode.rpt";
SqlConnection Con = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
SqlParameter BranchID_P = new SqlParameter("@BranchID", BranchID);
DataSet ds = AACommon.ReturnDatasetBySPForREPORT("BARCODE_ITEM_BRANCH_WISE", "VW_BARCODE_ITEM_BRANCH_WISE", Con, BranchID_P);
Session["RptDS"] = ds;
Response.Redirect("~/Reports/Viewer.aspx?name=" + rptName + "&no=0&RptTable=VW_BARCODE_ITEM_BRANCH_WISE");
}
protected void Button2_Click(object sender, EventArgs e)
{
//string rqID = Request.QueryString["ID"].ToString();//@DtFrom @DtTo
string rptName = "StockReport.rpt";
SqlConnection Con = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
SqlParameter DtFrom = new SqlParameter("@DtFrom", txtFrom.Text);
SqlParameter DtTo = new SqlParameter("@DtTo", txtTo.Text);
SqlParameter IsPurchase = new SqlParameter("@IsPurchase", "1");
SqlParameter IsSale = new SqlParameter("@IsSale", "0");
DataSet ds = AACommon.ReturnDatasetBySPForREPORT("INV_MATERIAL_STOCK", "INV_STOCK_RPT", Con, DtFrom, DtTo, IsPurchase, IsSale);
Session["RptDS"] = ds;
Session["param"] = "StartDate=" + txtFrom.Text + "&EndDate=" + txtTo.Text + "&MP=MATERIAL";
Response.Redirect("~/Reports/Viewer.aspx?name=" + rptName + "&no=3&RptTable=INV_STOCK_RPT&p1=" + txtFrom.Text + "&p2=" + txtTo.Text + "&p3=Material");
}
protected void Page_Load(object sender, EventArgs e)
{
string rqID = Request.QueryString["ID"].ToString();
string BID = Request.QueryString["BID"].ToString();
string T = rqID.Substring(0, 3);
string rptName = "";
rptName = "Voucher_His.rpt";
//if (T == "PVD")
//{
// rptName = "Voucher_His.rpt";
//}
//else
//{
// rptName = "Voucher_His_Credit.rpt";
//}
SqlConnection Con = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
SqlParameter ReqID = new SqlParameter("@TaskID", rqID);
SqlParameter Branch = new SqlParameter("@BranchID", BID);
DataSet ds = AACommon.ReturnDatasetBySPForREPORT("VoucherPRINT", "VW_LEDGER", Con, ReqID, Branch);
Session["RptDS"] = ds;
Response.Redirect("~/Reports/Viewer.aspx?name=" + rptName + "&no=0&RptTable=VW_LEDGER");
}
protected void Page_Load(object sender, EventArgs e)
{
string rqID = Request.QueryString["ID"].ToString();
string LType = Request.QueryString["Type"].ToString();
string BID = Request.QueryString["BID"].ToString();
if (LType == "Detail")
{
string rptName = "PO_His.rpt";
SqlConnection Con = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
SqlParameter ReqID = new SqlParameter("@SPID", rqID);
SqlParameter Branch = new SqlParameter("@BranchID", BID);
DataSet ds = AACommon.ReturnDatasetBySPForREPORT("PurchaseOrderPrint", "vwPurchseOrderPRINT", Con, ReqID, Branch);
foreach (DataRow dr in ds.Tables["vwPurchseOrderPRINT"].Rows)
{
SqlDataAdapter cd = new SqlDataAdapter("select AccountsTitle from Accounts where AccountsID='" + dr["CarryID"].ToString() + "'", Con);
DataTable dd = new DataTable();
cd.Fill(dd);
if (dd.Rows.Count > 0)
{
dr["CarryTitle"] = dd.Rows[0]["AccountsTitle"].ToString();
}
}
foreach (DataRow dr in ds.Tables["vwPurchseOrderPRINT"].Rows)
{
SqlDataAdapter cd = new SqlDataAdapter("select AccountsTitle from Accounts where AccountsID='" + dr["ExChargesID"].ToString() + "'", Con);
DataTable dd = new DataTable();
cd.Fill(dd);
if (dd.Rows.Count > 0)
{
dr["ExTitle"] = dd.Rows[0]["AccountsTitle"].ToString();
}
}
foreach (DataRow dr in ds.Tables["vwPurchseOrderPRINT"].Rows)
{
SqlDataAdapter cd = new SqlDataAdapter("select AccountsTitle from Accounts where AccountsID='" + dr["PackingID"].ToString() + "'", Con);
DataTable dd = new DataTable();
cd.Fill(dd);
if (dd.Rows.Count > 0)
{
dr["PackingTitle"] = dd.Rows[0]["AccountsTitle"].ToString();
}
}
ds.Tables["vwPurchseOrderPRINT"].AcceptChanges();
Session["RptDS"] = ds;
Response.Redirect("~/Reports/Viewer.aspx?name=" + rptName + "&no=0&RptTable=vwPurchseOrderPRINT");
}
else if (LType == "Local")
{
string rptName = "PO_His_Local.rpt";
SqlConnection Con = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
SqlParameter ReqID = new SqlParameter("@SPID", rqID);
SqlParameter Branch = new SqlParameter("@BranchID", BID);
DataSet ds = AACommon.ReturnDatasetBySPForREPORT("PurchaseOrderPrint", "vwPurchseOrderPRINT", Con, ReqID, Branch);
Session["RptDS"] = ds;
Response.Redirect("~/Reports/Viewer.aspx?name=" + rptName + "&no=0&RptTable=vwPurchseOrderPRINT");
}
}
protected void LoadReport(object sender, EventArgs e)
{
var BranchID = "";
string LType = Request.QueryString["LType"].ToString();
if (LType == "PKR")
{
if (Request.Cookies["BranchID"] != null)
{
BranchID = Request.Cookies["BranchID"].Value;
}
string rptName = "Ledger.rpt";
SqlConnection Con = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
SqlParameter AccountsID = new SqlParameter("@AccountsID", ddlITEM.SelectedValue);
SqlParameter DateFrom = new SqlParameter("@DateFrom", StartDate.Value);
SqlParameter DateEnd = new SqlParameter("@DateEnd", EndDate.Value);
SqlParameter Branch = new SqlParameter("@BranchID", BranchID);
ds = AACommon.ReturnDatasetBySPForREPORT("LedgerReport", "VW_LEDGER", Con, AccountsID, DateFrom, DateEnd, Branch);
if (ds.Tables[0].Rows.Count > 0)
{
string query = "";
if (ddlITEM.SelectedValue == "0")
{
query = "select * from Accounts where BranchID='" + BranchID + "'";
}
else
{
query = "select * from Accounts where AccountsID='" + ddlITEM.SelectedValue + "' and BranchID='" + BranchID + "'";
}
SqlDataAdapter da = new SqlDataAdapter(query, Con);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
string quersum = "select ISNULL(sum(DebitPKR) - Sum(CreditPKR),0) from Transaction_Detail where AccountID = '" + ddlITEM.SelectedValue + "' and Date < '" + StartDate.Value + "' AND (IsDelete = 0) and BranchID='" + BranchID + "'";
SqlDataAdapter dda = new SqlDataAdapter(quersum, Con);
DataTable dtt = new DataTable();
dda.Fill(dtt);
if (dtt.Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Select("AccountsID = '" + dt.Rows[i]["AccountsID"].ToString() + "'"))
{
string d = Convert.ToString(Convert.ToDecimal(row[10]));
string ee = Convert.ToString(dtt.Rows[0][0].ToString());
row[10] = Convert.ToString(Convert.ToDecimal(row[10]) + Convert.ToDecimal(dtt.Rows[0][0].ToString()));
}
ds.Tables[0].AcceptChanges();
}
}
}
}
else
{
if (ddlITEM.SelectedValue != "0")
{
string query = "";
if (ddlITEM.SelectedValue == "0")
{
query = "select * from Accounts where BranchID='" + BranchID + "'";
}
else
{
query = "select * from Accounts where AccountsID='" + ddlITEM.SelectedValue + "' and BranchID='" + BranchID + "'";
}
SqlDataAdapter da = new SqlDataAdapter(query, Con);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
string quersum = "select ISNULL(sum(DebitPKR) - Sum(CreditPKR),0) AS Opening from Transaction_Detail where AccountID = '" + ddlITEM.SelectedValue + "' AND (IsDelete = 0) and BranchID='" + BranchID + "'";
SqlDataAdapter dda = new SqlDataAdapter(quersum, Con);
DataTable dtt = new DataTable();
dda.Fill(dtt);
if (dtt.Rows.Count > 0)
{
decimal Basicopn = Convert.ToDecimal(dt.Rows[i]["OpDebit"].ToString()) - Convert.ToDecimal(dt.Rows[i]["OpCredit"].ToString());
string strd = dtt.Rows[0]["Opening"].ToString();
NumberStyles styles;
styles = NumberStyles.AllowExponent | NumberStyles.Number;
double dbl = Double.Parse(strd, styles);
decimal opn = Basicopn + Convert.ToDecimal(dbl);
//decimal opn = Basicopn + Convert.ToDecimal(dtt.Rows[0]["Opening"].ToString());
DataTable dtDs = new DataTable("VW_LEDGER");
dtDs.Columns.Add(new DataColumn("AccountsID", typeof(string)));
dtDs.Columns.Add(new DataColumn("AccountsTitle", typeof(string)));
dtDs.Columns.Add(new DataColumn("DebitPKR", typeof(float)));
dtDs.Columns.Add(new DataColumn("DebitRMB", typeof(float)));
dtDs.Columns.Add(new DataColumn("CreditPKR", typeof(float)));
dtDs.Columns.Add(new DataColumn("CreditRMB", typeof(float)));
dtDs.Columns.Add(new DataColumn("RMBValue", typeof(float)));
dtDs.Columns.Add(new DataColumn("TaskID", typeof(string)));
dtDs.Columns.Add(new DataColumn("Date", typeof(DateTime)));
dtDs.Columns.Add(new DataColumn("Narration", typeof(string)));
dtDs.Columns.Add(new DataColumn("Opening", typeof(float)));
dtDs.Columns.Add(new DataColumn("NarrationDetail", typeof(string)));
DataRow dr = dtDs.NewRow();
dr["AccountsID"] = dt.Rows[i]["AccountsID"].ToString();
dr["AccountsTitle"] = dt.Rows[i]["AccountsTitle"].ToString();
dr["DebitPKR"] = "0";
dr["DebitRMB"] = "0";
dr["CreditPKR"] = "0";
dr["CreditRMB"] = "0";
dr["RMBValue"] = "0";
dr["TaskID"] = "0";
dr["Date"] = DateTime.Now;
dr["Narration"] = "Default Closing Balance";
dr["Opening"] = opn;
dr["NarrationDetail"] = "Default Closing Balance";
dtDs.Rows.Add(dr);
ds.Tables.Remove("VW_LEDGER");
ds.Tables.Add(dtDs);
}
}
}
}
}
Session["RptDS"] = ds;
Response.Redirect("~/Reports/Viewer.aspx?name=" + rptName + "&no=0&RptTable=VW_LEDGER");
}
else if (LType == "RMB")
{
if (Request.Cookies["BranchID"] != null)
{
BranchID = Request.Cookies["BranchID"].Value;
}
string rptName = "LedgerRMB.rpt";
SqlConnection Con = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
SqlParameter AccountsID = new SqlParameter("@AccountsID", ddlITEM.SelectedValue);
SqlParameter DateFrom = new SqlParameter("@DateFrom", StartDate.Value);
SqlParameter DateEnd = new SqlParameter("@DateEnd", EndDate.Value);
SqlParameter Branch = new SqlParameter("@BranchID", BranchID);
DataSet ds = AACommon.ReturnDatasetBySPForREPORT("LedgerReport_RMB", "VW_LEDGER_RMB", Con, AccountsID, DateFrom, DateEnd, Branch);
if (ds.Tables[0].Rows.Count > 0)
{
string query = "";
if (ddlITEM.SelectedValue == "0")
{
query = "select * from Accounts where BranchID='" + BranchID + "'";
}
else
{
query = "select * from Accounts where AccountsID='" + ddlITEM.SelectedValue + "' and BranchID='" + BranchID + "'";
}
SqlDataAdapter da = new SqlDataAdapter(query, Con);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
string quersum = "select ISNULL(sum(DebitRMB) - Sum(CreditRMB),0) AS RMB,ISNULL(sum(DebitPKR) - Sum(CreditPKR),0) AS PKR from Transaction_Detail where AccountID = '" + ddlITEM.SelectedValue + "' and Date < '" + StartDate.Value + "' AND (IsDelete = 0) and BranchID='" + BranchID + "'";
SqlDataAdapter dda = new SqlDataAdapter(quersum, Con);
DataTable dtt = new DataTable();
dda.Fill(dtt);
if (dtt.Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Select("AccountsID = '" + dt.Rows[i]["AccountsID"].ToString() + "'"))
{
string RMB = Convert.ToString(Convert.ToDecimal(row[10]));
string eeRMB = Convert.ToString(dtt.Rows[0]["RMB"].ToString());
row[10] = Convert.ToString(Convert.ToDecimal(row[10]) + Convert.ToDecimal(dtt.Rows[0]["RMB"].ToString()));
row[11] = Convert.ToString(Convert.ToDecimal(row[11]) + Convert.ToDecimal(dtt.Rows[0]["PKR"].ToString()));
}
ds.Tables[0].AcceptChanges();
}
}
}
}
else
{
if (ddlITEM.SelectedValue != "0")
{
string query = "";
if (ddlITEM.SelectedValue == "0")
{
query = "select * from Accounts where BranchID='" + BranchID + "'";
}
else
{
query = "select * from Accounts where AccountsID='" + ddlITEM.SelectedValue + "' and BranchID='" + BranchID + "'";
}
SqlDataAdapter da = new SqlDataAdapter(query, Con);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
string quersum = "select ISNULL(sum(DebitRMB) - Sum(CreditRMB),0) AS OpeningRMB,ISNULL(sum(DebitPKR) - Sum(CreditPKR),0) AS OpeningPKR from Transaction_Detail where AccountID = '" + ddlITEM.SelectedValue + "' AND (IsDelete = 0) and BranchID='" + BranchID + "'";
SqlDataAdapter dda = new SqlDataAdapter(quersum, Con);
DataTable dtt = new DataTable();
dda.Fill(dtt);
if (dtt.Rows.Count > 0)
{
decimal Basicopn = Convert.ToDecimal(dt.Rows[i]["OpDebitRMB"].ToString()) - Convert.ToDecimal(dt.Rows[i]["OpCreditRMB"].ToString());
/// COnvert Exponential to Numbers Start
string strdRMB = dtt.Rows[0]["OpeningRMB"].ToString();
NumberStyles stylesRmb;
stylesRmb = NumberStyles.AllowExponent | NumberStyles.Number;
double dblRmb = Double.Parse(strdRMB, stylesRmb);
/// COnvert Exponential to Numbers END
//decimal opn = Basicopn + Convert.ToDecimal(dtt.Rows[0]["OpeningRMB"].ToString());
decimal opn = Basicopn + Convert.ToDecimal(dblRmb);
decimal Basicopnpkr = Convert.ToDecimal(dt.Rows[i]["OpDebit"].ToString()) - Convert.ToDecimal(dt.Rows[i]["OpCredit"].ToString());
string strd = dtt.Rows[0]["OpeningPKR"].ToString();
NumberStyles styles;
styles = NumberStyles.AllowExponent | NumberStyles.Number;
double dbl = Double.Parse(strd, styles);
//decimal opnpkr = Basicopnpkr + Convert.ToDecimal(dtt.Rows[0]["OpeningPKR"].ToString());
decimal opnpkr = Basicopnpkr + Convert.ToDecimal(dbl);
DataTable dtDs = new DataTable("VW_LEDGER_RMB");
dtDs.Columns.Add(new DataColumn("AccountsID", typeof(string)));
dtDs.Columns.Add(new DataColumn("AccountsTitle", typeof(string)));
dtDs.Columns.Add(new DataColumn("DebitPKR", typeof(float)));
dtDs.Columns.Add(new DataColumn("DebitRMB", typeof(float)));
dtDs.Columns.Add(new DataColumn("CreditPKR", typeof(float)));
dtDs.Columns.Add(new DataColumn("CreditRMB", typeof(float)));
dtDs.Columns.Add(new DataColumn("RMBValue", typeof(float)));
dtDs.Columns.Add(new DataColumn("TaskID", typeof(string)));
dtDs.Columns.Add(new DataColumn("Date", typeof(DateTime)));
dtDs.Columns.Add(new DataColumn("Narration", typeof(string)));
dtDs.Columns.Add(new DataColumn("OpeningRMB", typeof(float)));
dtDs.Columns.Add(new DataColumn("OpeningPKR", typeof(float)));
dtDs.Columns.Add(new DataColumn("NarrationDetail", typeof(string)));
DataRow dr = dtDs.NewRow();
dr["AccountsID"] = dt.Rows[i]["AccountsID"].ToString();
dr["AccountsTitle"] = dt.Rows[i]["AccountsTitle"].ToString();
dr["DebitPKR"] = "0";
dr["DebitRMB"] = "0";
dr["CreditPKR"] = "0";
dr["CreditRMB"] = "0";
dr["RMBValue"] = "0";
dr["TaskID"] = "0";
dr["Date"] = DateTime.Now;
dr["Narration"] = "Default Closing Balance";
dr["OpeningRMB"] = opn;
dr["OpeningPKR"] = opnpkr;
dr["NarrationDetail"] = "Default Closing Balance";
dtDs.Rows.Add(dr);
ds.Tables.Remove("VW_LEDGER_RMB");
ds.Tables.Add(dtDs);
}
}
}
}
}
Session["RptDS"] = ds;
Response.Redirect("~/Reports/Viewer.aspx?name=" + rptName + "&no=0&RptTable=VW_LEDGER_RMB");
}
}
