private void button1_Click(object sender, EventArgs e)
{
bool flag;
//MessageBox.Show(d_id.ToString());
if (d_id > 0)
{
try
{
//insert into db donation history
BloodBankData bbd = new BloodBankData();
DONATION_HISTORY dh = new DONATION_HISTORY();
dh.DONOR_ID = d_id;
dh.RECIEVER_ID = u_id;
dh.DONATION_DATE = dateTimePicker1.Value;
flag = bbd.insertDonationHistory(dh);
if (flag == true)
{
MessageBox.Show("Blood Request Successful!", "Blood Request", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Error While Requesting Blood!", "Error", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
}
}
else
{
MessageBox.Show("Select a valid column first", "Inavlid Selection", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
}
}
public bool insertDonationHistory(DONATION_HISTORY obj)
{
int val = 0;
try
{
SqlDbDataAccess da = new SqlDbDataAccess();
SqlCommand cmd = da.GetCommand("INSERT INTO [dbo].[DONATION_HISTORY] ([DONOR_ID],[RECIEVER_ID],[DONATION_DATE])" + "VALUES (@DONOR_ID, @RECIEVER_ID, @DONATION_DATE)");
SqlParameter p1 = new SqlParameter("@DONOR_ID", SqlDbType.Int);
p1.Value = obj.DONOR_ID;
SqlParameter p2 = new SqlParameter("@RECIEVER_ID", SqlDbType.Int);
p2.Value = obj.RECIEVER_ID;
SqlParameter p3 = new SqlParameter("@DONATION_DATE", SqlDbType.Date);
p3.Value = obj.DONATION_DATE;
cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
cmd.Parameters.Add(p3);
cmd.Connection.Open();
val = cmd.ExecuteNonQuery();
cmd.Connection.Close();
}
catch (Exception ex)
{
}
return(val > 0);
}
