protected void Button1_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
string CS = ConfigurationManager.ConnectionStrings["bloodbankConnectionString"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
con.Open();
donors d = new donors();
d.d_id = Convert.ToInt32(deltxt.Text);
SqlCommand cmd = new SqlCommand("delete from comments where comment_id=" + d.d_id + "or comment_fk_fromprofileid=" + d.d_id + " or comment_fk_onprofileid=" + d.d_id, con);
cmd.ExecuteNonQuery();
SqlCommand cmd1 = new SqlCommand("delete from donor_img where img_fk_donor=" + d.d_id, con);
cmd1.ExecuteNonQuery();
SqlCommand cmd2 = new SqlCommand("delete from user_donor where d_id=" + d.d_id, con);
cmd2.ExecuteNonQuery();
con.Close();
}
Response.Redirect("~/views/delete.aspx");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
donors d = new donors();
d.d_email = txtemail.Text;
d.d_password = txtpassword.Text;
d.d_cnic = txtcnic.Text;
d.d_name = txtname.Text;
d.d_age = Convert.ToInt32(DropDownList3.SelectedValue);
d.d_hosp_id = Convert.ToInt32(DropDownList2.SelectedValue);
d.d_contact = txtcontact.Text;
d.d_bgroup = DropDownList2.SelectedValue.ToString();
insert i = new insert();
string msg = i.insert_donor(d);
if (msg == "-1")
{
}
else
{
Session["u_id"] = msg;
Response.Redirect("~/views/profile.aspx");
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
string CS = ConfigurationManager.ConnectionStrings["bloodbankConnectionString"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
con.Open();
donors d = new donors();
d.d_id = Convert.ToInt32(txtid.Text);
SqlCommand cmd1 = new SqlCommand("insert into bloodbottle select d_blood,d_id from user_donor where d_id=" + d.d_id, con);
cmd1.ExecuteNonQuery();
SqlCommand cmd2 = new SqlCommand("update user_donor set d_status = 1 where d_id=" + d.d_id, con);
cmd2.ExecuteNonQuery();
con.Close();
Response.Write("<script>alert('Blood Donated') </script>");
}
Response.Redirect("~/views/donorAdd.aspx");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
donors d = new donors();
d.d_email = txtemail.Text;
d.d_password = txtcpassword.Text;
d.d_cinc = txtcnic.Text;
d.d_name = txtname.Text;
d.d_age = Convert.ToInt32(DropDownList3.SelectedValue);
d.d_contact = TXTCONTCT.Text;
d.d_hb = (float)Convert.ToDouble(txthb.Text);
d.d_sex = DropDownList5.Text;
d.d_bgroup = DropDownList1.SelectedValue.ToString();
d.d_status = Convert.ToString(0);
insert i = new insert();
string msg = i.insert_donor(d);
if (msg == "-1")
{
Label1.Text = "some error";
}
else
{
HttpCookie cookie = new HttpCookie("DONOR");
cookie["email"] = Server.UrlEncode(txtemail.Text);
cookie["pwd"] = Server.UrlEncode(txtcpassword.Text);
cookie.Expires = DateTime.Now.AddDays(30);
Response.Cookies.Add(cookie);
Session["u_id"] = msg;
Response.Redirect("~/views/profile.aspx");
}
}
}
protected void Button2_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
donors d = new donors();
d.d_email = txtemail.Text;
d.d_password = txtpass.Text;
d.d_cinc = txtcnic.Text;
d.d_name = txtname.Text;
d.d_age = Convert.ToInt32(DropDownList1.SelectedValue);
d.d_contact = txtcontact.Text;
d.d_bgroup = DropDownList2.SelectedValue.ToString();
d.d_hb = (float)Convert.ToDouble(txthb.Text);
string CS = ConfigurationManager.ConnectionStrings["bloodbankConnectionString"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
con.Open();
SqlCommand cmd = new SqlCommand("update user_donor set d_email = '" + d.d_email + "', d_password ='******',d_cnic =" + d.d_cinc + ",d_name = '" + d.d_name + "',d_age = " + d.d_age + ",d_contact = " + d.d_contact + ",d_blood = " + d.d_bgroup + ", d_hb=" + d.d_hb + " where d_id = " + Session["u_id"], con);
cmd.ExecuteNonQuery();
con.Close();
Response.Redirect("~/views/profile.aspx");
}
}
}
public int Delete(donors existingdonors)
{
return(AllocateRepo().Delete(existingdonors));
}
public int Update(donors existingdonors)
{
return(AllocateRepo().Update(existingdonors));
}
public long Create(donors newdonors)
{
return(AllocateRepo().Create(newdonors));
}
