private void btnUpdate_Click(object sender, RoutedEventArgs e)
{
try
{
BloodBank_HospitalBL bbBL = new BloodBank_HospitalBL();
if (bbBL.ValidateBloodBankUpdateDetails(txtBBName.Text, txtBBAddress.Text, txtBBCity.Text, txtBBContactNo.Text))
{
BloodBankDetails details = new BloodBankDetails
{
BloodBankID = cmbBloodBankID.SelectedValue.ToString(),
BloodBankName = txtBBName.Text,
Address = txtBBAddress.Text,
City = txtBBCity.Text,
ContactNumber = long.Parse(txtBBContactNo.Text)
};
if (bbBL.UpdateBloodBankDetailsBL(details))
{
gb.Visibility = Visibility.Hidden;
MessageBox.Show("Blood Bank Details Updated", "Blood Bank Management System");
}
else
{
gb.Visibility = Visibility.Hidden;
MessageBox.Show("Blood Bank Details Could Not Be Updated", "Blood Bank Management System");
}
}
}catch (BloodBankExceptions ex) { MessageBox.Show(ex.Message, "Warning"); }
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Warning");
}
}
private void cmbBloodBankID_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
try
{
BloodBank_HospitalBL bbBL = new BloodBank_HospitalBL();
BloodBankDetails bankDetails = bbBL.SearchBloodBankDetailsBL(cmbBloodBankID.SelectedValue.ToString());
if (bankDetails != null)
{
txtBBName.Text = bankDetails.BloodBankName;
txtBBAddress.Text = bankDetails.Address;
txtBBCity.Text = bankDetails.City;
txtBBContactNo.Text = (bankDetails.ContactNumber).ToString();
gb.Visibility = Visibility.Visible;
}
else
{
gb.Visibility = Visibility.Hidden;
MessageBox.Show("Blood Bank Details Do Not Exist", "Blood Bank Management System");
}
}
catch (BloodBankExceptions ex)
{
MessageBox.Show(ex.Message, "Warning");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Warning");
}
}
public bool AddBloodBankDetailsBL(BloodBankDetails bloodBankDetails)
{//Insert Blood Bank Details Into Blood Bank Table
try
{
BloodBank_HospitalDL bbDAL = new BloodBank_HospitalDL();
return(bbDAL.AddBloodBankDetailsDL(bloodBankDetails));
}
catch (BloodBankExceptions)
{
throw;
}
}
public bool UpdateBloodBankDetailsBL(BloodBankDetails bloodBankDetails)
{//Update Blood Bank Details In Blood Bank Table
try
{
BloodBank_HospitalDL bbDAL = new BloodBank_HospitalDL();
return(bbDAL.UpdateBloodBankDetailsDL(bloodBankDetails));
}
catch (BloodBankExceptions)
{
throw;
}
}
public bool AddBloodBankDetailsDL(BloodBankDetails bbDetails)
{//Insert Blood Bank Details Into Blood Bank Table
bool DetailsAdded = false;
try
{
con = new SqlConnection(conStr);
com = new SqlCommand("BBank.uspAddBloodBankDetails2", con);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@bbID", bbDetails.BloodBankID);
com.Parameters.AddWithValue("@bbName", bbDetails.BloodBankName);
com.Parameters.AddWithValue("@bbAddress", bbDetails.Address);
com.Parameters.AddWithValue("@bbCity", bbDetails.City);
com.Parameters.AddWithValue("@bbContactNo", bbDetails.ContactNumber);
//com.Parameters.AddWithValue("@bbUserID", bbDetails.UserID);
//com.Parameters.AddWithValue("@bbPassword", bbDetails.Password);
con.Open();
com.ExecuteNonQuery();
DetailsAdded = true;
}
catch (BloodBankExceptions) { throw; }
catch (SqlException)
{
throw;
}
catch (SystemException)
{
throw;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return(DetailsAdded);
}
public BloodBankDetails SearchBloodBankDetailsDL(string bbID)
{//Search For Blood Bank Details
BloodBankDetails p = null;
try
{
con = new SqlConnection(conStr);
com = new SqlCommand("BBank.uspSearchBloodBankDetails", con);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@bbID", bbID);
con.Open();
SqlDataReader dr = com.ExecuteReader();
if (dr.HasRows)
{
dr.Read();
p = new BloodBankDetails
{
BloodBankName = dr["BloodBankName"].ToString(),
Address = dr["Address"].ToString(),
City = dr["City"].ToString(),
ContactNumber = long.Parse(dr["ContactNumber"].ToString()),
};
dr.Close();
}
}
catch (BloodBankExceptions) { throw; }
catch (SqlException)
{
throw;
}
catch (SystemException)
{
throw;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return(p);
}
private void BtnSubmit_Click(object sender, RoutedEventArgs e)
{
try
{
BloodBank_HospitalBL bloodBankBL = new BloodBank_HospitalBL();
if (bloodBankBL.ValidateBloodBankData(txtbbID.Text, txtbbName.Text, txtbbAddress.Text, txtbbCity.Text, txtbbContactNo.Text))
{
if (bloodBankBL.VerifyBloodBankIDBL(txtbbID.Text) == 0)
{
BloodBankDetails bbDetails = new BloodBankDetails
{
BloodBankID = txtbbID.Text,
BloodBankName = txtbbName.Text,
Address = txtbbAddress.Text,
City = txtbbCity.Text,
ContactNumber = long.Parse(txtbbContactNo.Text),
//UserID = txtbbUserName.Text,
//Password = pwbbbPassword.Password.ToString()
};
if (bloodBankBL.AddBloodBankDetailsBL(bbDetails))
{
MessageBox.Show("Details Added", "Blood Bank Management System");
}
else
{
MessageBox.Show("Details could not be added", "Blood Bank Management System");
}
}
else
{
MessageBox.Show("Blood Bank ID already exists", "Blood Bank Management System");
}
}
}
catch (BloodBankExceptions ex)
{
MessageBox.Show(ex.Message, "Warning");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Warning");
}
}
