protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
con.Open();
String email = "";
string name = "";
string ph = "";
int id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value.ToString());
SqlDataAdapter sda = new SqlDataAdapter("Select * from tbl_doctor where d_id='" + id + "'", con);
DataTable dt = new DataTable();
sda.Fill(dt);
if (dt.Rows.Count > 0)
{
email = obj.DecryptString(dt.Rows[0]["d_email"].ToString());
name = dt.Rows[0]["d_name"].ToString();
ph = dt.Rows[0]["d_contact"].ToString();
}
string s = obj.DecryptString(ph);
string dph = "+966" + s.ToString();
ob1.Message(dph.ToString(), "sorry!! " + name + " your account rejected from Hakkeem");
string dph1 = "+91" + s.ToString();
ob1.Message(dph1.ToString(), "sorry!! " + name + " your account rejected from Hakkeem");
Email_To_AccountRejection(email);
// Email(email, "sorry!! " + name + " your account rejected from Hakkeem");
if (con.State.ToString() == "Closed")
{
con.Open();
}
//SqlCommand cmd8 = new SqlCommand("Delete from tbl_doctor_location where d_id='" + id + "'", con);
//cmd8.ExecuteNonQuery();
SqlCommand cmd = new SqlCommand("Delete from tbl_doctor where d_id='" + id + "'", con);
cmd.ExecuteNonQuery();
con.Close();
doctor_rqst();
//if (Session["Language"].ToString() == "Auto")
//{
Response.Redirect("~/BookDoc Admin/Doctor request.aspx");
//}
//else
//{
// Response.Redirect("~/BookDoc Admin/Doctor request.aspx?l=ar-EG");
//}
}
public void users()
{
//var user = from item in db.tbl_temp_signups orderby item.id descending select item;
con.Open();
SqlDataAdapter Sda = new SqlDataAdapter("Select * from tbl_temp_signup order by id desc", con);
DataTable dt = new DataTable();
Sda.Fill(dt);
if (dt.Rows.Count > 0)
{
GridView1.DataSource = dt;
GridView1.DataBind();
}
foreach (GridViewRow gr in GridView1.Rows)
{
string hakkeemid = (gr.FindControl("Label2") as Label).Text;
string contact = (gr.FindControl("Label3") as Label).Text;
Label lbl3 = gr.FindControl("Label3") as Label;
string s = obj.DecryptString(lbl3.Text);
if (s.StartsWith("5") == true)
{
lbl3.Text = "+966" + s;
}
else
{
lbl3.Text = "+91" + s;
}
}
con.Close();
}
public void doctor()
{
con.Open();
SqlDataAdapter Sda = new SqlDataAdapter("Select * from tbl_temp_doctor order by d_id desc", con);
DataTable dt = new DataTable();
Sda.Fill(dt);
if (dt.Rows.Count > 0)
{
GridView1.DataSource = dt;
GridView1.DataBind();
}
foreach (GridViewRow gr in GridView1.Rows)
{
Label cno = new Label();
cno = (Label)GridView1.Rows[gr.RowIndex].FindControl("Label11");
string lno = obj.DecryptString(cno.Text);
Label lno1 = new Label();
lno1 = (Label)GridView1.Rows[gr.RowIndex].FindControl("Label11");
lno1.Text = lno;
Label email = new Label();
email = (Label)GridView1.Rows[gr.RowIndex].FindControl("Label12");
string lemail = obj.DecryptString(email.Text);
Label email1 = new Label();
email1 = (Label)GridView1.Rows[gr.RowIndex].FindControl("Label12");
email1.Text = lemail;
//
}
}
