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