private void btnDelete_Click(object sender, EventArgs e)
{
SqlConnection conn;
conn = DB.getinstance();
conn.Open();
ClsDonor D = new ClsDonor();
D.Delete = Convert.ToInt32(txtDelete.Text);
try
{
D.delete();
MessageBox.Show("Donor deleted succesffully.");
dataGridView1.DataSource = null;
dataGridView2.DataSource = new ClsDonor.DonorDAL().GetAllDonor();
dataGridView2.Enabled = true;
}
catch (Exception)
{
MessageBox.Show("Donor Can't be deleted.");
}
txtDelete.Text = "";
}
private void txtId_TextChanged(object sender, EventArgs e)
{
DB.getinstance();
string name2 = new ClsDonor.DonorDAL().GetGenderById(Convert.ToInt32(txtId.Text));
if (txtId.Text == "")
{
}
else
{
txtName.Text = new ClsDonor.DonorDAL().GetNameById(Convert.ToInt32(txtId.Text));
txtAge.Text = new ClsDonor.DonorDAL().GetAgeById(Convert.ToInt32(txtId.Text));
bg.Text = new ClsDonor.DonorDAL().GetBGById(Convert.ToInt32(txtId.Text));
if (name2 == "Male")
{
btnFemale.Checked = false;
btnMale.Checked = true;
}
else if (name2 == "Female")
{
btnMale.Checked = false;
btnFemale.Checked = true;
}
txtContact.Text = new ClsDonor.DonorDAL().GetPhoneById(Convert.ToInt32(txtId.Text));
txtDAddress.Text = new ClsDonor.DonorDAL().GetAddressById(Convert.ToInt32(txtId.Text));
}
}
private void txtId_TextChanged(object sender, EventArgs e)
{
string gender = new ClsPatient.PatientDAL().GetGenderByID(Convert.ToInt32(txtId.Text));
DB.getinstance();
if (txtId.Text == "")
{
}
else
{
txtPName.Text = new ClsPatient.PatientDAL().GetNameByID(Convert.ToInt32(txtId.Text));
txtPAge.Text = new ClsPatient.PatientDAL().GetAgeByID(Convert.ToInt32(txtId.Text));
if (gender == "Male")
{
btnFemale.Checked = false;
btnMale.Checked = true;
}
else if (gender == "Female")
{
btnMale.Checked = false;
btnFemale.Checked = true;
}
txtBG.Text = new ClsPatient.PatientDAL().GetBGByID(Convert.ToInt32(txtId.Text));
txtPContact.Text = new ClsPatient.PatientDAL().GetPhoneByID(Convert.ToInt32(txtId.Text));
txtPAddress.Text = new ClsPatient.PatientDAL().GetAddressByID(Convert.ToInt32(txtId.Text));
date.Text = new ClsPatient.PatientDAL().GetDateByID(Convert.ToInt32(txtId.Text));
txtPDisease.Text = new ClsPatient.PatientDAL().GetDiseaseByID(Convert.ToInt32(txtId.Text));
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
try
{
SqlConnection conn;
conn = DB.getinstance();
conn.Open();
SqlCommand cmd;
cmd = new SqlCommand("SELECT password FROM Admin WHERE username=@username", conn);
cmd.Parameters.AddWithValue("@username", txtUsername.Text);
string i;
i = cmd.ExecuteScalar().ToString();
if (txtPassword.Text == i)
{
new BloodBank().Show();
Hide();
}
else
{
lblErrorMsg.Text = "UserName or Password is Incorrect";
}
conn.Close();
}
catch (Exception)
{
lblErrorMsg.Text = "UserName or Password is Incorrect";
}
}
private void Main_Load(object sender, EventArgs e)
{
DB.getinstance();
txtDonorId.Text = new ClsDonor.DonorDAL().GetDonorId();
dataGridView2.DataSource = new ClsDonor.DonorDAL().GetAllDonor();
dataGridView2.Enabled = true;
}
private void Patient_Load(object sender, EventArgs e)
{
DB.getinstance();
txtPatientId.Text = new ClsPatient.PatientDAL().GetPatientId();
dataGridView1.DataSource = new ClsPatient.PatientDAL().GetAllPAtients();
dataGridView1.Enabled = true;
}
private void BloodBank_Load(object sender, EventArgs e)
{
DB.getinstance();
DGBB.DataSource = new ClsBloodBank.BBDAL().GetAllBB();
DGBB.Enabled = true;
DGReports.DataSource = new ClsBloodBank.BBDAL().Reports();
DGReports.Enabled = true;
}
public DataTable Reports()
{
conn = DB.getinstance();
dad = new SqlDataAdapter("SELECT d.Date, d.Donor_id, d.Donor_Name, d.Donor_BloodGroup, b.Branchid, b.City from Donor d, BloodBank b", conn);
DataTable dtBloodbank = new DataTable();
dad.Fill(dtBloodbank);
return(dtBloodbank);
}
public DataTable GetAllBB()
{
conn = DB.getinstance();
dad = new SqlDataAdapter("Select * from BloodBank", conn);
DataTable dtBloodbank = new DataTable();
dad.Fill(dtBloodbank);
return(dtBloodbank);
}
public string GetDonorId()
{
conn = DB.getinstance();
conn.Open();
cmd = new SqlCommand("select count (*) +1from Donor", conn);
string id = Convert.ToString(cmd.ExecuteScalar());
conn.Close();
return(id);
}
public DataTable GetAllDonor()
{
conn = DB.getinstance();
dad = new SqlDataAdapter("Select * from Donor", conn);
DataTable dtDonor = new DataTable();
dad.Fill(dtDonor);
return(dtDonor);
}
public DataTable GetAllPAtients()
{
conn = DB.getinstance();
dad = new SqlDataAdapter("Select * from Patient", conn);
DataTable dtPatients = new DataTable();
dad.Fill(dtPatients);
return(dtPatients);
}
public string GetAgeByID(int id)
{
conn = DB.getinstance();
conn.Open();
cmd = new SqlCommand("select Patient_Age from Patient where Patient_Id=@id", conn);
cmd.Parameters.AddWithValue("@id", id);
string name = Convert.ToString(cmd.ExecuteScalar());
conn.Close();
return(name);
}
public DataTable GetDonorById(int id)
{
conn = DB.getinstance();
conn.Open();
DataTable dtDonor = new DataTable();
dad = new SqlDataAdapter("SELECT * FROM Donor where Donor_Id = @id ", conn);
dad.SelectCommand.Parameters.AddWithValue("@id", id);
dad.Fill(dtDonor);
return(dtDonor);
}
public DataTable GetDDonorsByBG(string bg)
{
conn = DB.getinstance();
conn.Open();
DataTable dtBG = new DataTable();
dad = new SqlDataAdapter("SELECT * FROM Donor where Donor_BloodGroup LIKE @bg ", conn);
dad.SelectCommand.Parameters.AddWithValue("@bg", bg);
dad.Fill(dtBG);
return(dtBG);
}
public void delete()
{
SqlConnection conn;
conn = DB.getinstance();
conn.Open();
SqlCommand cmd;
cmd = new SqlCommand("DELETE Donor WHERE Donor_Id=@id", conn);
cmd.Parameters.AddWithValue("@id", Delete);
cmd.ExecuteNonQuery();
}
public string GetAddressById(int id)
{
conn = DB.getinstance();
conn.Open();
cmd = new SqlCommand("SELECT Donor_Address FROM Donor WHERE Donor_Id=@id", conn);
cmd.Parameters.AddWithValue("@id", id);
string name = Convert.ToString(cmd.ExecuteScalar());
conn.Close();
return(name);
}
private void btnInsert_Click(object sender, EventArgs e)
{
SqlConnection conn;
conn = DB.getinstance();
conn.Open();
ClsDonor D = new ClsDonor();
D.Donor_Name = txtDonorName.Text;
D.Donor_Age = Convert.ToInt32(txtDonorAge.Text);
D.Donor_BloodGroup = txtBloodGroup.Text;
if (rdbMale.Checked == true)
{
D.Donor_Gender = rdbMale.Text;
}
else if (rdbFemale.Checked == true)
{
D.Donor_Gender = rdbFemale.Text;
}
D.Donor_Phone = Convert.ToInt32(txtDonorContact.Text);
D.Donor_Address = txtAddress.Text;
D.Donor_Id = Convert.ToInt32(txtDonorId.Text);
D.Branch_Id = Convert.ToInt32(txtBranch.Text);
try
{
D.insert();
MessageBox.Show("Info inserted");
txtDonorId.Text = new ClsDonor.DonorDAL().GetDonorId();
txtDonorName.Text = "";
txtDonorAge.Text = "";
txtBloodGroup.Text = "";
txtBloodGroup.Text = "";
rdbMale.Checked = false;
rdbFemale.Checked = false;
txtDonorContact.Text = "";
txtAddress.Text = "";
txtBranch.Text = "";
dataGridView2.DataSource = new ClsDonor.DonorDAL().GetAllDonor();
dataGridView2.Enabled = true;
}
catch (Exception)
{
MessageBox.Show("Kindly check your data..");
}
}
private void btnInsert_Click(object sender, EventArgs e)
{
SqlConnection conn;
conn = DB.getinstance();
conn.Open();
ClsPatient P = new ClsPatient();
P.Patient_Name = txtName.Text;
P.Patient_Age = Convert.ToInt32(txtAge.Text);
if (rdbMale.Checked == true)
{
P.Patient_Gender = rdbMale.Text;
}
else if (rdbFemale.Checked == true)
{
P.Patient_Gender = rdbFemale.Text;
}
P.Patient_BloodGroup = txtGroup.Text;
P.Patient_Phone = Convert.ToInt32(txtContact.Text);
P.Patient_Address = txtAddress.Text;
P.Requested_Date = Convert.ToDateTime(datetime.Text);
P.Patient_Disease = txtDisease.Text;
try
{
P.insert();
MessageBox.Show("Info inserted");
dataGridView1.DataSource = new ClsPatient.PatientDAL().GetAllPAtients();
dataGridView1.Enabled = true;
}
catch (Exception)
{
MessageBox.Show("Kindly check your data..");
}
txtPatientId.Text = new ClsPatient.PatientDAL().GetPatientId();
txtName.Text = "";
txtAge.Text = "";
txtGroup.Text = "";
rdbMale.Checked = false;
rdbFemale.Checked = false;
txtContact.Text = "";
txtAddress.Text = "";
txtDisease.Text = "";
}
private void bttnUpdate_Click(object sender, EventArgs e)
{
SqlConnection conn;
conn = DB.getinstance();
conn.Open();
ClsPatient Ptn = new ClsPatient();
Ptn.Patient_Id = Convert.ToInt32(txtId.Text);
Ptn.Patient_Name = txtPName.Text;
Ptn.Patient_Age = Convert.ToInt32(txtPAge.Text);
if (btnMale.Checked == true)
{
Ptn.Patient_Gender = btnMale.Text;
}
else if (btnFemale.Checked == true)
{
Ptn.Patient_Gender = btnFemale.Text;
}
Ptn.Patient_BloodGroup = txtBG.Text;
Ptn.Patient_Phone = Convert.ToInt32(txtPContact.Text);
Ptn.Patient_Address = txtPAddress.Text;
Ptn.Requested_Date = Convert.ToDateTime(date.Text);
Ptn.Patient_Disease = txtPDisease.Text;
try
{
Ptn.update();
MessageBox.Show("Patient Updated.");
dataGridView1.DataSource = new ClsPatient.PatientDAL().GetAllPAtients();
dataGridView1.Enabled = true;
}
catch (Exception)
{
MessageBox.Show("Error");
}
txtId.Text = "";
txtPName.Text = "";
txtPAge.Text = "";
txtBG.Text = "";
btnMale.Checked = false;
btnFemale.Checked = false;
txtPContact.Text = "";
txtPAddress.Text = "";
txtPDisease.Text = "";
}
public void update()
{
SqlConnection conn;
conn = DB.getinstance();
conn.Open();
SqlCommand cmd;
cmd = new SqlCommand("update Donor SET Donor_Name=@name,Donor_Age=@age,Donor_BloodGroup=@bg,Donor_Gender=@gender,Donor_Phone=@phone,Donor_Address=@address Where Donor_Id=@id", conn);
cmd.Parameters.AddWithValue("@id", Id);
cmd.Parameters.AddWithValue("@name", Name);
cmd.Parameters.AddWithValue("@age", Age);
cmd.Parameters.AddWithValue("@bg", BloodGroup);
cmd.Parameters.AddWithValue("@gender", Gender);
cmd.Parameters.AddWithValue("@phone", Phone);
cmd.Parameters.AddWithValue("@address", Address);
// cmd.Parameters.AddWithValue("@date", DateTime.Now);
cmd.ExecuteNonQuery();
}
private void btnUpdate_Click(object sender, EventArgs e)
{
SqlConnection conn;
conn = DB.getinstance();
conn.Open();
ClsDonor Donor = new ClsDonor();
Donor.Id = Convert.ToInt32(txtId.Text);
Donor.Name = txtName.Text;
Donor.Age = Convert.ToInt32(txtAge.Text);
Donor.BloodGroup = bg.Text;
if (btnMale.Checked == true)
{
Donor.Gender = btnMale.Text;
}
else if (btnFemale.Checked == true)
{
Donor.Gender = btnFemale.Text;
}
Donor.Phone = Convert.ToInt32(txtContact.Text);
Donor.Address = txtDAddress.Text;
try
{
Donor.update();
MessageBox.Show("Donor Updated.");
dataGridView2.DataSource = new ClsDonor.DonorDAL().GetAllDonor();
dataGridView2.Enabled = true;
}
catch (Exception)
{
MessageBox.Show("Error");
}
txtId.Text = "";
txtName.Text = "";
txtAge.Text = "";
bg.Text = "";
btnMale.Checked = false;
btnFemale.Checked = false;
txtContact.Text = "";
txtDAddress.Text = "";
}
public void insert()
{
SqlConnection conn;
conn = DB.getinstance();
conn.Open();
SqlCommand cmd;
cmd = new SqlCommand("INSERT INTO Patient(Patient_Name,Patient_Age,Patient_Gender,Patient_BloodGroup,Patient_Phone,Patient_Address,Requested_Date,Patient_Disease)VALUES(@name,@age,@gender,@bg,@phone,@address,@date,@disease)", conn);
cmd.Parameters.AddWithValue("@name", Patient_Name);
cmd.Parameters.AddWithValue("@age", Patient_Age);
cmd.Parameters.AddWithValue("@gender", Patient_Gender);
cmd.Parameters.AddWithValue("@bg", Patient_BloodGroup);
cmd.Parameters.AddWithValue("@phone", Patient_Phone);
cmd.Parameters.AddWithValue("@address", Patient_Address);
cmd.Parameters.AddWithValue("@date", Requested_Date);
cmd.Parameters.AddWithValue("@disease", Patient_Disease);
cmd.ExecuteNonQuery();
}
public void update()
{
SqlConnection conn;
conn = DB.getinstance();
conn.Open();
SqlCommand cmd;
cmd = new SqlCommand("update Patient SET Patient_Name=@name,Patient_Age=@age,Patient_Gender=@gender,Patient_BloodGroup=@bg,Patient_Phone=@phone,Patient_Address=@address, Requested_Date=@date,Patient_Disease=@disease Where Patient_Id=@id", conn);
cmd.Parameters.AddWithValue("@id", Patient_Id);
cmd.Parameters.AddWithValue("@name", Patient_Name);;
cmd.Parameters.AddWithValue("@age", Patient_Age);
cmd.Parameters.AddWithValue("@gender", Patient_Gender);
cmd.Parameters.AddWithValue("@bg", Patient_BloodGroup);
cmd.Parameters.AddWithValue("@phone", Patient_Phone);
cmd.Parameters.AddWithValue("@address", Patient_Address);
cmd.Parameters.AddWithValue("@date", Requested_Date);
cmd.Parameters.AddWithValue("@disease", Patient_Disease);
cmd.ExecuteNonQuery();
}
public void insert()
{
SqlConnection conn;
conn = DB.getinstance();
conn.Open();
SqlCommand cmd;
SqlCommand cmd2;
cmd = new SqlCommand("INSERT INTO Donor(Donor_Name,Donor_Age,Donor_BloodGroup,Donor_Gender,Donor_Phone,Donor_Address,Date)VALUES(@name,@age,@bg,@gender,@phone,@address,@date)", conn);
cmd.Parameters.AddWithValue("@name", Donor_Name);
cmd.Parameters.AddWithValue("@age", Donor_Age);
cmd.Parameters.AddWithValue("@bg", Donor_BloodGroup);
cmd.Parameters.AddWithValue("@gender", Donor_Gender);
cmd.Parameters.AddWithValue("@phone", Donor_Phone);
cmd.Parameters.AddWithValue("@address", Donor_Address);
cmd.Parameters.AddWithValue("@date", DateTime.Now);
cmd.ExecuteNonQuery();
cmd2 = new SqlCommand("INSERT INTO Blood(Donor_Id,BranchId)VALUES(@id,@BID)", conn);
cmd2.Parameters.AddWithValue("@id", Donor_Id);
cmd2.Parameters.AddWithValue("@BID", Branch_Id);
cmd2.ExecuteNonQuery();
}
private void btnDelete_Click(object sender, EventArgs e)
{
SqlConnection conn;
conn = DB.getinstance();
conn.Open();
ClsPatient patient = new ClsPatient();
patient.Patient_Id = Convert.ToInt32(txtDelete.Text);
try
{
patient.delet();
MessageBox.Show("Patient deleted succesffully.");
dataGridView2.DataSource = null;
dataGridView1.DataSource = new ClsPatient.PatientDAL().GetAllPAtients();
dataGridView1.Enabled = true;
}
catch (Exception)
{
MessageBox.Show("Patient Can't be deleted.");
}
txtDelete.Text = "";
}
private void pageDonor_Click(object sender, EventArgs e)
{
DB.getinstance();
txtDonorId.Text = new ClsDonor.DonorDAL().GetDonorId();
}
