void depositchk()
{
try
{
var da = new SqlDataAdapter();
var ds = new DataSet();
da = new SqlDataAdapter("SELECT Id,cheque from deposit where status = '0'", cn);
ds = new DataSet();
da.Fill(ds);
GVacct.DataSource = ds;
GVacct.DataBind();
GVacct.RowStyle.Height = 150;
Label6.Visible = false;
Label7.Visible = false;
Label8.Visible = false;
Label9.Visible = false;
Label10.Visible = false;
Label11.Visible = false;
LblAccountNo.Visible = false;
LblClientId.Visible = false;
LblDate.Visible = false;
LblTime.Visible = false;
LblAccountNo.Visible = false;
LblStatus.Visible = false;
ImageButton2.Visible = false;
ImgDelete.Visible = false;
ImgUpdate.Visible = false;
TxtAmount.Visible = false;
}
catch { }
}
/// <summary>
/// ////////////////////////////////////
/// </summary>
void acountgv()
{
try
{
var da = new SqlDataAdapter();
var ds = new DataSet();
da = new SqlDataAdapter("SELECT AccountType.Type AS [Account Type], Account.Account_No AS [Account Number], Account.Bank_Transit_No AS [Transit Number], Account.Amount FROM Account INNER JOIN AccountType ON Account.Account_Type_Id = AccountType.Account_Type_Id where Client_Id = '" + fn + "'", cn);
ds = new DataSet();
da.Fill(ds);
GVacct.DataSource = ds;
GVacct.DataBind();
GVacct.RowStyle.Height = 150;
}
catch { }
}
void depositchk()
{
try
{
var da = new SqlDataAdapter();
var ds = new DataSet();
da = new SqlDataAdapter("Select Request_Id AS [Request Id],Client_Id AS [Client ID],Date from CreditRequest where status = '0'", cn);
ds = new DataSet();
da.Fill(ds);
GVacct.DataSource = ds;
GVacct.DataBind();
GVacct.RowStyle.Height = 150;
lblCid.Visible = false;
LblMS.Visible = false;
LblStat.Visible = false;
LblAL.Visible = false;
Label11.Visible = false;
LblClientId.Visible = false;
LblMonthlySalary.Visible = false;
LblStatus.Visible = false;
ImgDelete.Visible = false;
ImgUpdate.Visible = false;
LblStatus.Visible = false;
LblEmail.Visible = false;
LblFirstName.Visible = false;
LblLastName.Visible = false;
LblMonthlySalary.Visible = false;
LblCN.Visible = false;
LblBT.Visible = false;
LblAL.Visible = false;
Label13.Visible = false;
Label14.Visible = false;
LblCardNo.Visible = false;
LblBankTransit.Visible = false;
TxtAmountLimit.Visible = false;
LblIssueDate.Visible = false;
LblExpieryDate.Visible = false;
LblFN.Visible = false;
LblEM.Visible = false;
LblLN.Visible = false;
}
catch { }
}
