private List <EmployeeBankDetails> getEmployeeBankDetails(string connectionString, long pContactId)
{
employeeBankdetailsList = new List <EmployeeBankDetails>();
try
{
using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(connectionString, CommandType.Text, "SELECT empbankid,employeeid, bankaccountname, bankaccountno,bankbranch, bankifsccode, bankname, isprimaryaccount, statusid FROM tblmstemployeebankdetails where employeeid=" + pContactId + " and statusid=" + Convert.ToInt32(Status.Active) + "; "))
{
while (dr.Read())
{
EmployeeBankDetails employeeKYC = new EmployeeBankDetails
{
pBankRecordid = Convert.ToInt64(dr["empbankid"]),
pEmployeeID = Convert.ToInt64(dr["employeeid"]),
pBankAccountname = Convert.ToString(dr["bankaccountname"]),
pBankAccountNo = Convert.ToString(dr["bankaccountno"]),
pBankBranch = Convert.ToString(dr["bankbranch"]),
pBankifscCode = Convert.ToString(dr["bankifsccode"]),
pBankName = Convert.ToString(dr["bankname"]),
pIsprimaryAccount = Convert.ToBoolean(dr["isprimaryaccount"]),
ptypeofoperation = "UPDATE"
};
employeeBankdetailsList.Add(employeeKYC);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(employeeBankdetailsList);
}
private void Button_Click(object sender, RoutedEventArgs e)
{
EmployeeBankDetails bankDetails = new EmployeeBankDetails();
bankDetails.employeeID = Int32.Parse(txtemployeeID.Text);
bankDetails.bankName = txtBankName.Text;
bankDetails.accountNumber = txtAccountNumber.Text;
bankDetails.ifscCode = txtifscdetails.Text;
bankDetails.nameInBank = TxtNameinBank.Text;
Datalayer dl = new Datalayer();
Response res = dl.addbankdetailstodatabase(bankDetails);
if (res.success)
{
MessageBox.Show("Details Saved");
txtAccountNumber.Text = "";
txtBankName.Text = "";
txtemployeeID.Text = "";
txtifscdetails.Text = "";
TxtNameinBank.Text = "";
TxtPanNumber.Text = "";
}
else if (res.isException)
{
MessageBox.Show("Exception occured : " + res.exception);
}
}
