public DataTable SearchInfo(SearchCustomerInfo searchObj)
{
SearchRipository searchRipoObj = new SearchRipository();
DataTable searchInfo = searchRipoObj.SearchInfo(searchObj);
return(searchInfo);
}
public DataTable SearchInfo(SearchCustomerInfo searchObj)
{
DataTable dt = new DataTable();
string connectionString =
@"Server=DESKTOP-063GM06\SQLEXPRESS;Database=CUSTOMERDATABASE;user=sa;password=mh_kaiser";
string query = @"SELECT AccountNumber FROM CustomerAndAccountInfos WHERE AccountNumber='" + searchObj.AccountNo + "'";
SqlConnection conn = new SqlConnection(connectionString);
SqlCommand comd = new SqlCommand(query, conn);
conn.Open();
SqlDataReader dr = comd.ExecuteReader();
if (dr.Read())
{
dr.Close();
conn.Close();
query = "SELECT CI.AccountNumber AccountNumber,CI.CustomerName CustomerName,CI.OpeningDate OpeningDate," +
" TR.Amount Balance FROM CustomerAndAccountInfos CI " +
"INNER JOIN Transactions TR ON CI.AccountNumber=TR.AccountNo WHERE CI.AccountNumber='" + searchObj.AccountNo + "'";
comd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(comd);
da.Fill(dt);
conn.Close();
}
return(dt);
}
public bool CheckInfo(SearchCustomerInfo searchObj)
{
SearchRipository searchRipoObj = new SearchRipository();
bool checkInfo = searchRipoObj.CheckInfo(searchObj);
return(checkInfo);
}
private void searchButton_Click(object sender, EventArgs e)
{
SearchCustomerInfo searchObj = new SearchCustomerInfo();
searchObj.AccountNo = searchTextBox.Text;
if (searchObj.AccountNo == "")
{
MessageBox.Show("Null value not accepted !");
return;
}
try
{
SearchManager searchManagerObj = new SearchManager();
bool checkInfo = searchManagerObj.CheckInfo(searchObj);
if (checkInfo == false)
{
MessageBox.Show("Sorry ! Your requested Account not found !");
return;
}
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
}
try
{
SearchManager searchManagerObj = new SearchManager();
DataTable searchInfo = searchManagerObj.SearchInfo(searchObj);
searchDataGridView.DataSource = searchInfo;
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
}
}
public bool CheckInfo(SearchCustomerInfo searchObj)
{
bool checkInfo = false;
string connectionString =
@"Server=DESKTOP-063GM06\SQLEXPRESS;Database=CUSTOMERDATABASE;user=sa;password=mh_kaiser";
string query = @"SELECT AccountNumber FROM CustomerAndAccountInfos WHERE AccountNumber='" + searchObj.AccountNo + "'";
SqlConnection conn = new SqlConnection(connectionString);
SqlCommand comd = new SqlCommand(query, conn);
conn.Open();
SqlDataReader dr = comd.ExecuteReader();
if (dr.Read())
{
dr.Close();
checkInfo = true;
conn.Close();
}
return(checkInfo);
}
