C#

protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                CurUserID = Convert.ToInt64(Session["UserID"]);
                CurrLocID = Convert.ToInt64(HttpContext.Current.Session["LocID"]);
                CurrCompID = Convert.ToInt64(HttpContext.Current.Session["CompID"]);
                if (CurUserID == 0)
                {
                    Response.Redirect("~/Logout.aspx");
                }
                else
                {
                    BindAccounDetails();
                    GetMonthWiseReports();
                   
                }
            }
        }

        private void BindAccounDetails()
        {
            CurrLocID = Convert.ToInt64(HttpContext.Current.Session["LocID"]);
            CurrCompID = Convert.ToInt64(HttpContext.Current.Session["CompID"]);
            try
            {
               
                DataTable dt = new DataTable();
                SerChequePaymentDetails SerObjChq = new SerChequePaymentDetails();
             
                dt = SerObjChq.BindAccounDetails(CurrLocID, CurrCompID);
                ddlAccname.DataSource = dt;
                ddlAccname.DataTextField = "Acc_Name";
                ddlAccname.DataValueField = "Acc_No";
                ddlAccname.DataBind();
                RadComboBoxItem item = new RadComboBoxItem("Select", "0");
                ddlAccname.Items.Insert(0, item);
            }
            catch (Exception ex)
            {
            }
        }

        protected void btnSearch_Click(object sender, EventArgs e)
        {
            DivReport.Visible = true;
            GetMonthWiseReports();
            
        }

        private void GetMonthWiseReports()
        {
            string LocationName = string.Empty, CompanyName = string.Empty;
            try
            {
                rptvw.Reset();
                rptvw.ProcessingMode = ProcessingMode.Local;
                rptvw.LocalReport.ReportPath = Server.MapPath("~/Reports/RDLC/MonthWiseLedger.rdlc");
                string accname = string.Empty;
                Int64 AccNo = 0;
                
                
                
                DataTable dt_PurchaseData = SerLedgerMaster.GetMonthwiseledgerReport(AccNo).Tables[0];
                dt_PurchaseData.Columns.Add("Serial_No");
                Int32 RowCount = 0;
                foreach (DataRow dr in dt_PurchaseData.Rows)
                {
                    RowCount++;
                    dr["Serial_No"] = RowCount;
                }
                ReportDataSource rptSource = new ReportDataSource("MonthWiseLedger", dt_PurchaseData);
                rptvw.LocalReport.DataSources.Add(rptSource);
                rptvw.LocalReport.Refresh();
            }
            catch (Exception ex)
            {
                throw (ex);
            }
        }

public static DataSet GetMonthwiseledgerReport(Int64 accname)
        {
            try
            {
                MySqlConnection mySQLConnection = new MySqlConnection(ConfigurationManager.ConnectionStrings["MMDBConn"].ToString());

                DataSet objDataSet = new DataSet();
                MySqlCommand command = new MySqlCommand();
                command.Connection = mySQLConnection;
                command.CommandType = CommandType.StoredProcedure;
                command.CommandTimeout = 600;

                command.CommandText = "USP_GetMonthWiseLedger";
                //command.Parameters.AddWithValue("@frmdate", frmdate);
                //command.Parameters.Add("@frmdate", MySqlDbType.String).Value = frmdate;
                //command.Parameters.AddWithValue("@todate", todate);
                //command.Parameters.Add("@todate", MySqlDbType.String).Value = todate;
                //command.Parameters.AddWithValue("@AccNo", accname);
                command.Parameters.Add("@AccNo", MySqlDbType.Int64).Value = accname;
                mySQLConnection.Open();
                MySqlDataAdapter SqlDa = new MySqlDataAdapter(command);
                SqlDa.Fill(objDataSet);
                int count = objDataSet.Tables[0].Rows.Count;
                return objDataSet;
            }
            catch (Exception ex)
            {
                throw (ex);
            }
        }

DataBind();

Session["id"] = txtUserId.Text;

waghniteen wrote:

what we do?