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