private void btnUpdateCampDetails_Click(object sender, RoutedEventArgs e)
{
try
{
BloodDonationCampBL bb = new BloodDonationCampBL();
if (bb.ValidateBloodDonationCampData(txtBloodDonationCampId.Text, txtCampName.Text, txtAddress.Text, txtCity.Text, txtBloodBankId.Text, txtCampStartDate.Text, txtCampEndDate.Text))
{
if (bb.validateCampIdModify(txtBloodDonationCampId.Text))
{
BloodDonationCamp b = new BloodDonationCamp
{
BloodDonationCampId = txtBloodDonationCampId.Text,
CampName = txtCampName.Text,
Address = txtAddress.Text,
City = txtCity.Text,
CampStartDate = Convert.ToDateTime(txtCampStartDate.Text),
CampEndDate = Convert.ToDateTime(txtCampEndDate.Text)
};
if (bb.ModifyCampBLL(b))
{
txtBloodDonationCampId.IsEnabled = true;
gbModify.Visibility = Visibility.Hidden;
MessageBox.Show("Blood Donation Camp Info Saved.");
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnsearchCamp_Click(object sender, RoutedEventArgs e)
{
try
{
BloodDonationCampBL bb = new BloodDonationCampBL();
BloodDonationCamp b = bb.SearchCampBLL(txtBloodDonationCampId.Text);
if (b != null)
{
txtCampName.Text = b.CampName;
txtAddress.Text = b.Address;
txtCity.Text = b.City;
txtBloodBankId.Text = b.BloodBankId.ToString();
txtCampStartDate.Text = b.CampStartDate.ToString();
txtCampEndDate.Text = b.CampEndDate.ToString();
gbModify.Visibility = Visibility.Visible;
txtBloodDonationCampId.IsEnabled = false;
}
else
{
gbModify.Visibility = Visibility.Hidden;
MessageBox.Show
(string.Format("Blood Donation camp with id {0} does not exists.", txtBloodDonationCampId.Text));
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public bool ModifyCampBLL(BloodDonationCamp modify)
{
try
{
BloodDonationCampDL bd = new BloodDonationCampDL();
return(bd.ModifyCampDAL(modify));
}
catch
{
throw;
}
}
//--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
public bool ArrangeCampDAL(BloodDonationCamp arrange)
{
bool arrangeCamp = false;
try
{
cmd = new SqlCommand();
cmd.CommandText = "BBank.ArrangeCamp";
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BloodDonationCampId", arrange.BloodDonationCampId);
cmd.Parameters.AddWithValue("@CampName", arrange.CampName);
cmd.Parameters.AddWithValue("@Address", arrange.Address);
cmd.Parameters.AddWithValue("@City", arrange.City);
cmd.Parameters.AddWithValue("@BloodBankId", arrange.BloodBankId);
cmd.Parameters.AddWithValue("@CampStartDate", arrange.CampStartDate);
cmd.Parameters.AddWithValue("@CampEndDate", arrange.CampEndDate);
con.Open();
int noOfRowsAffected = cmd.ExecuteNonQuery();
if (noOfRowsAffected == 1)
{
arrangeCamp = true;
}
}
catch (SqlException)
{
throw;
}
catch (SystemException)
{
throw;
}
catch (Exception)
{
MessageBox.Show("Please enter valid entries.");
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return(arrangeCamp);
}
public bool ArrangeCampBLL(BloodDonationCamp arrange)
{
bool arrangeCamp = false;
try
{
BloodDonationCampDL bBMSDAL = new BloodDonationCampDL();
arrangeCamp = bBMSDAL.ArrangeCampDAL(arrange);
}
catch
{
throw;
}
return(arrangeCamp);
}
public BloodDonationCamp SearchCampDAL(string bloodDonationCampID)
{
BloodDonationCamp p = null;
try
{
cmd = new SqlCommand();
cmd.CommandText = "BBank.SearchCamp";
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BloodDonationCampId", bloodDonationCampID);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
dr.Read();
p = new BloodDonationCamp
{
BloodDonationCampId = dr["BloodDonationCampId"].ToString(),
CampName = dr["CampName"].ToString(),
Address = dr["Address"].ToString(),
City = dr["City"].ToString(),
BloodBankId = dr["BloodBankId"].ToString(),
CampStartDate = DateTime.Parse(dr["CampStartDate"].ToString()),
CampEndDate = DateTime.Parse(dr["CampEndDate"].ToString())
};
dr.Close();
}
}
catch
{
throw;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return(p);
}
//--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
public bool ModifyCampDAL(BloodDonationCamp modify)
{
bool result = false;
try
{
cmd = new SqlCommand();
cmd.CommandText = "BBank.ModifyCamp";
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BloodDonationCampId", modify.BloodDonationCampId);
cmd.Parameters.AddWithValue("@CampName", modify.CampName);
cmd.Parameters.AddWithValue("@Address", modify.Address);
cmd.Parameters.AddWithValue("@City", modify.City);
cmd.Parameters.AddWithValue("@CampStartDate", modify.CampStartDate);
cmd.Parameters.AddWithValue("@CampEndDate", modify.CampEndDate);
con.Open();
int noOfRowsAffected = cmd.ExecuteNonQuery();
if (noOfRowsAffected == 1)
{
result = true;
}
}
catch
{
throw;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return(result);
}
private void btnArrange_Click(object sender, RoutedEventArgs e)
{
try
{
BloodDonationCampBL bl = new BloodDonationCampBL();
if (bl.ValidateBloodDonationCampData(txtBloodDonationCampId.Text, txtCampName.Text, txtAddress.Text, txtCity.Text, txtBloodBankId.Text, txtCampStartDate.Text, txtCampEndDate.Text))
{
if (bl.validateCampIdArrange(txtBloodDonationCampId.Text))
{
BloodDonationCamp arrange = new BloodDonationCamp()
{
BloodDonationCampId = txtBloodDonationCampId.Text,
CampName = txtCampName.Text,
Address = txtAddress.Text,
City = txtCity.Text,
BloodBankId = txtBloodBankId.Text,
CampStartDate = Convert.ToDateTime(txtCampStartDate.Text),
CampEndDate = Convert.ToDateTime(txtCampEndDate.Text)
};
if (bl.ArrangeCampBLL(arrange))
{
MessageBox.Show(" Blood Donation Camp Arranged Successfully");
}
else
{
MessageBox.Show("Details Not Added");
}
}
}
}
catch
{
throw;
}
}
