Esempio n. 1
0
    void investmentList()
    {
        try
        {
            var da = new SqlDataAdapter();
            var ds = new DataSet();


            da = new SqlDataAdapter("SELECT Investment.Investment_id,InvestmentType.Type AS [Investment Type], AccountType.Type AS [Paid from Account Type], Investment.StartDate, Investment.EndDate, Investment.YearInvestment AS [Year Investment], Investment.Amount FROM Investment INNER JOIN InvestmentType ON Investment.Investment_Type_Id = InvestmentType.Investment_Type_Id INNER JOIN AccountType ON Investment.Account_Type_Id = AccountType.Account_Type_Id WHERE Investment.Client_Id = '" + fn + "'", cn);
            ds = new DataSet();

            da.Fill(ds);

            GVClientBillList.DataSource = ds;
            GVClientBillList.DataBind();


            if (GVClientBillList.Rows.Count != 0)
            {
                ImageButton3.Visible = true;
                LblError.Visible     = false;
            }
            else
            {
                LblError.Visible     = true;
                LblError.Text        = "No Investment Record Found";
                ImageButton3.Visible = false;
            }


            this.GVClientBillList.Columns[0].Visible = false;
        }

        catch { }
    }
    void ClientBillList()
    {
        try
        {
            var da = new SqlDataAdapter();
            var ds = new DataSet();


            da = new SqlDataAdapter("Select StatementId AS Date,Date,Title, Account,Credit,Debit,Total  from Statement where Client_Id = '" + fn + "' and Account = '" + an1 + "' order by StatementId desc", cn);
            ds = new DataSet();

            da.Fill(ds);
            GVClientBillList.DataSource = ds;
            GVClientBillList.DataBind();

            if (GVClientBillList.Rows.Count != 0)
            {
                ImageButton4.Visible = true;
                LblError.Visible     = false;
            }
            else
            {
                LblError.Visible     = true;
                LblError.Text        = "No Investment Record Found";
                ImageButton4.Visible = false;
            }

            this.GVClientBillList.Columns[0].Visible = false;
        }

        catch { }
    }
    protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
    {
        try
        {
            string sd1 = ddlDay1.Text + "/" + ddlMonth1.Text + "/" + ddlYear1.Text;
            string ed1 = ddlDay2.Text + "/" + ddlMonth2.Text + "/" + ddlYear2.Text;

            DateTimeFormatInfo StartDate = new DateTimeFormatInfo();
            StartDate.ShortDatePattern = "dd/MM/yyyy";
            StartDate.DateSeparator    = "/";
            DateTime objDate = Convert.ToDateTime(sd1, StartDate);

            DateTimeFormatInfo EndDate = new DateTimeFormatInfo();
            EndDate.ShortDatePattern = "dd/MM/yyyy";
            EndDate.DateSeparator    = "/";
            DateTime objDate2 = Convert.ToDateTime(ed1, StartDate);

            var da = new SqlDataAdapter();
            var ds = new DataSet();


            da = new SqlDataAdapter("SELECT Recipient.Name AS [Recipient Name], Recipient.Account_No AS [Recipient Account No], Recipient.Bank_Transit_No AS [Bank Transit Number], Transit.Amount, Transit.Date FROM Transit INNER JOIN Recipient ON Transit.Recipient_Id = Recipient.Recipient_Id WHERE (Transit.Date BETWEEN '" + objDate + "' AND '" + objDate2 + "') AND (Recipient.Client_Id = '" + fn + "')", cn);
            ds = new DataSet();

            da.Fill(ds);
            GVClientBillList.DataSource = ds;
            GVClientBillList.DataBind();


            ImageButton3.Visible = true;
        }

        catch { }
    }
    void investmentList()
    {
        try
        {
            var da = new SqlDataAdapter();
            var ds = new DataSet();


            da = new SqlDataAdapter("Select Type AS [Investment Type],Description from InvestmentType", cn);
            ds = new DataSet();

            da.Fill(ds);
            GVClientBillList.DataSource = ds;
            GVClientBillList.DataBind();
        }

        catch { }
    }
Esempio n. 5
0
    protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
    {
        try
        {
            string sd1 = ddlDay1.Text + "/" + ddlMonth1.Text + "/" + ddlYear1.Text;
            string ed1 = ddlDay2.Text + "/" + ddlMonth2.Text + "/" + ddlYear2.Text;

            DateTimeFormatInfo StartDate = new DateTimeFormatInfo();
            StartDate.ShortDatePattern = "dd/MM/yyyy";
            StartDate.DateSeparator    = "/";
            DateTime objDate = Convert.ToDateTime(sd1, StartDate);

            DateTimeFormatInfo EndDate = new DateTimeFormatInfo();
            EndDate.ShortDatePattern = "dd/MM/yyyy";
            EndDate.DateSeparator    = "/";
            DateTime objDate2 = Convert.ToDateTime(ed1, StartDate);

            var da = new SqlDataAdapter();
            var ds = new DataSet();


            da = new SqlDataAdapter("SELECT Client.First_Name AS [Client Name], deposit.Amount, deposit.date,  deposit.Account_No FROM deposit INNER JOIN Client ON deposit.Client_Id = Client.Client_Id WHERE deposit.status = '1' AND Client.Client_Id = '" + fn + "' AND deposit.date BETWEEN '" + objDate + "' AND '" + objDate2 + "'", cn);
            ds = new DataSet();

            da.Fill(ds);
            GVClientBillList.DataSource = ds;
            GVClientBillList.DataBind();


            if (GVClientBillList.Rows.Count != 0)
            {
                ImageButton3.Visible = true;
                LblError.Visible     = false;
            }
            else
            {
                LblError.Visible     = true;
                LblError.Text        = "No Record Found";
                ImageButton3.Visible = false;
            }
        }

        catch { }
    }
    protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
    {
        try
        {
            string sd1 = ddlDay1.Text + "/" + ddlMonth1.Text + "/" + ddlYear1.Text;
            string ed1 = ddlDay2.Text + "/" + ddlMonth2.Text + "/" + ddlYear2.Text;

            DateTimeFormatInfo StartDate = new DateTimeFormatInfo();
            StartDate.ShortDatePattern = "dd/MM/yyyy";
            StartDate.DateSeparator    = "/";
            DateTime objDate = Convert.ToDateTime(sd1, StartDate);

            DateTimeFormatInfo EndDate = new DateTimeFormatInfo();
            EndDate.ShortDatePattern = "dd/MM/yyyy";
            EndDate.DateSeparator    = "/";
            DateTime objDate2 = Convert.ToDateTime(ed1, StartDate);

            var da = new SqlDataAdapter();
            var ds = new DataSet();


            da = new SqlDataAdapter("SELECT ClientBill.Name, ClientBill.Transit_Id, ClientBill.Account_Number, Bill.Amount, Bill.date FROM Bill INNER JOIN ClientBill ON Bill.Client_Bill_Id = ClientBill.Client_Bill_Id where Bill.Client_Id = '" + fn + "' and Bill.date between '" + objDate + "' and '" + objDate2 + "'", cn);
            ds = new DataSet();

            da.Fill(ds);
            GVClientBillList.DataSource = ds;
            GVClientBillList.DataBind();


            if (GVClientBillList.Rows.Count != 0)
            {
                ImageButton3.Visible = true;
                LblError.Visible     = false;
            }
            else
            {
                LblError.Visible     = true;
                LblError.Text        = "No Record Found";
                ImageButton3.Visible = false;
            }
        }

        catch { }
    }
Esempio n. 7
0
    void ClientBillList()
    {
        try
        {
            var da = new SqlDataAdapter();
            var ds = new DataSet();


            da = new SqlDataAdapter("Select Staff_Id AS [Select],First_Name AS [First Name], Email  from Staff ", cn);
            ds = new DataSet();

            da.Fill(ds);
            GVClientBillList.DataSource = ds;
            GVClientBillList.DataBind();
            this.GVClientBillList.Columns[0].Visible = false;
        }

        catch { }
    }
Esempio n. 8
0
    void ClientBillList()
    {
        try
        {
            var da = new SqlDataAdapter();
            var ds = new DataSet();


            da = new SqlDataAdapter("Select Client_Bill_Id AS [Select],Account_Number, Name  from ClientBill where Client_Id = '" + LblClientId.Text + "'", cn);
            ds = new DataSet();

            da.Fill(ds);
            GVClientBillList.DataSource = ds;
            GVClientBillList.DataBind();
            this.GVClientBillList.Columns[0].Visible = false;
        }

        catch { }
    }
Esempio n. 9
0
    void recipientList()
    {
        try
        {
            var da = new SqlDataAdapter();
            var ds = new DataSet();


            da = new SqlDataAdapter("Select Recipient_Id AS [Select], Name,Account_No,Email  from Recipient where Client_Id = '" + LblClientId.Text + "'", cn);
            ds = new DataSet();

            da.Fill(ds);
            GVClientBillList.DataSource = ds;
            GVClientBillList.DataBind();

            this.GVClientBillList.Columns[0].Visible = false;
        }

        catch { }
    }
    void investmentList()
    {
        try
        {
            var da = new SqlDataAdapter();
            var ds = new DataSet();


            da = new SqlDataAdapter("SELECT Investment.Investment_id,InvestmentType.Type AS [Investment Type], AccountType.Type AS [Paid from Account Type], Investment.StartDate, Investment.EndDate, Investment.YearInvestment AS [Year Investment], Investment.Amount FROM Investment INNER JOIN InvestmentType ON Investment.Investment_Type_Id = InvestmentType.Investment_Type_Id INNER JOIN AccountType ON Investment.Account_Type_Id = AccountType.Account_Type_Id WHERE Investment.Client_Id = '" + fn + "'", cn);
            ds = new DataSet();

            da.Fill(ds);

            GVClientBillList.DataSource = ds;
            GVClientBillList.DataBind();



            //  this.GVClientBillList.Columns[0].Visible = false;
        }

        catch { }
    }