public bool UpdateDetails(Case_Bank_Details bankModel)
{
if (checkForEmpty(bankModel))
{
if (validateChars(bankModel))
{
if (insertData(bankModel))
{
bankModel.bankErrorMessage = "Details Updated Successfully";
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
else
{
return(false);
}
}
private void Button_SaveBankDetails_Click(object sender, EventArgs e)
{
label_BankDetails_ErrorMessage.Text = "";
if (Combo_BankUpdate.SelectedIndex != 0)
{
Case_Bank_Details bankModel = new Case_Bank_Details();
UpdateBankControl bankControl = new UpdateBankControl();
bankModel.bankName = TextBox_BankName.Text;
bankModel.bankBranch = TextBox_BankBranch.Text;
bankModel.bankIfsc = TextBox_IFSC.Text;
bankModel.bankAccountNumber = TextBox_AccountNumber.Text;
bankModel.bankAccountHolderName = TextBox_AccountHolder.Text;
bankModel.bankAccountType = TextBox_AccountType.Text;
bankModel.bank_caseSelected = ((KeyValuePair <int, string>)Combo_BankUpdate.SelectedItem).Key;
if (bankControl.UpdateDetails(bankModel))
{
MessageBox.Show(bankModel.bankErrorMessage);
}
else
{
MessageBox.Show(bankModel.bankErrorMessage);
}
}
else
{
MessageBox.Show("Please Select a Case from the Dropdwn", "Case not Selected", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public Case_Bank_Details getBankData(int id)
{
string query = "Select * from bank_tb where person_id=" + id;
Case_Bank_Details bank = new Case_Bank_Details();
try
{
using (SqlConnection connect = new SqlConnection(this.connection))
{
connect.Open();
SqlCommand com = new SqlCommand(query, connect);
SqlDataReader reader = com.ExecuteReader();
while (reader.Read())
{
bank.bankName = reader["name"].ToString();
bank.bankBranch = reader["bank_branch"].ToString();
bank.bankIfsc = reader["ifsc"].ToString();
bank.bankAccountNumber = reader["account_no"].ToString();
bank.bankAccountHolderName = reader["account_holder"].ToString();
bank.bankAccountType = reader["account_type"].ToString();
}
return(bank);
}
}
catch (Exception e)
{
bank.bankErrorMessage = e.Message;
return(bank);
}
}
private bool validateChars(Case_Bank_Details bankModel)
{
Validate vd = new Validate();
if (vd.validateAddress(bankModel.bankName))
{
if (vd.validateAddress(bankModel.bankBranch))
{
if (vd.validateEducation(bankModel.bankIfsc))
{
if (vd.validateNumber(bankModel.bankAccountNumber))
{
if (vd.validateName(bankModel.bankAccountHolderName))
{
if (vd.validateName(bankModel.bankAccountType))
{
return(true);
//insert
}
else
{
bankModel.bankErrorMessage = "Invalid Account Type";
return(false);
}
}
else
{
bankModel.bankErrorMessage = "Invalid Account Holder's Name";
return(false);
}
}
else
{
bankModel.bankErrorMessage = "Invalid Account Nnumber";
return(false);
}
}
else
{
bankModel.bankErrorMessage = "Invalid IFSC";
return(false);
}
}
else
{
bankModel.bankErrorMessage = "Invalid Branch Name";
return(false);
}
}
else
{
bankModel.bankErrorMessage = "Invalid Bank Name";
return(false);
}
}
private bool checkForEmpty(Case_Bank_Details bankModel)
{
if (bankModel.bankName == "" || bankModel.bankBranch == "" || bankModel.bankAccountNumber == "" || bankModel.bankAccountNumber == "")
{
bankModel.bankErrorMessage = "Feilds marked with * cannot be blank";
return(false);
}
else
{
return(true);
}
}
private bool insertData(Case_Bank_Details bankModel)
{
string Query = "";
try
{
using (SqlConnection connect = new SqlConnection(connection))
{
Query = "UPDATE bank_tb SET name='" + bankModel.bankName + "', bank_branch='" + bankModel.bankBranch + "', ifsc='" + bankModel.bankIfsc + "',account_no='" + bankModel.bankAccountNumber + "',account_holder='" + bankModel.bankAccountHolderName + "',account_type='" + bankModel.bankAccountType + "' WHERE person_id=" + bankModel.bank_caseSelected;
SqlCommand com = new SqlCommand(Query, connect);
connect.Open();
com.ExecuteNonQuery();
return(true);
}
}
catch (Exception e)
{
bankModel.bankErrorMessage = e.Message;
return(false);
}
}
private void Combo_BankUpdate_SelectionChangeCommitted(object sender, EventArgs e)
{
if (Combo_BankUpdate.SelectedIndex != 0)
{
int keyy = ((KeyValuePair <int, string>)Combo_BankUpdate.SelectedItem).Key;
UpdateBankControl bankCt = new UpdateBankControl();
Case_Bank_Details bank_details = bankCt.getBankData(keyy);
TextBox_BankName.Text = bank_details.bankName;
TextBox_BankBranch.Text = bank_details.bankBranch;
TextBox_IFSC.Text = bank_details.bankIfsc;
TextBox_AccountNumber.Text = bank_details.bankAccountNumber;
TextBox_AccountHolder.Text = bank_details.bankAccountHolderName;
TextBox_AccountType.Text = bank_details.bankAccountType;
if (TextBox_BankName.Text == "")
{
MessageBox.Show("Please fill the Bank details for this case in 'New Case' Tab and then try to Update", "Bank details not Found!", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
}
label_BankDetails_ErrorMessage.Text = bank_details.bankErrorMessage;
}
}
private void Button_SaveBankDetails_Click(object sender, EventArgs e)
{
label_BankDetails_ErrorMessage.Text = "";
BankDetail_Control BankControl = new BankDetail_Control();
Case_Bank_Details bankDetails = new Case_Bank_Details();
bankDetails.bank_caseSelected = combo_bank.SelectedIndex;
if (BankControl.caseSelected(bankDetails))
{
bankDetails.bankName = TextBox_BankName.Text;
bankDetails.bankBranch = TextBox_BankBranch.Text;
bankDetails.bankIfsc = TextBox_IFSC.Text;
bankDetails.bankAccountNumber = TextBox_AccountNumber.Text;
bankDetails.bankAccountHolderName = TextBox_AccountHolder.Text;
bankDetails.bankAccountType = TextBox_AccountType.Text;
bankDetails.bank_caseSelected = ((KeyValuePair <int, string>)combo_bank.SelectedItem).Key;
if (BankControl.SaveBankDetails(bankDetails))
{
label_BankDetails_ErrorMessage.Text = bankDetails.bankErrorMessage;
LoadBankGrid(((KeyValuePair <int, string>)ComboSelectCase.SelectedItem).Key);
LoadBankGrid(((KeyValuePair <int, string>)combo_bank.SelectedItem).Key);
clearBankDetails();
}
else
{
label_BankDetails_ErrorMessage.Text = bankDetails.bankErrorMessage;
}
}
else
{
MessageBox.Show("Please Select a Case from the Dropdwn", "Case not Selected", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
