public List <clsdocprp> Find_Rec(Int32 doccod)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("fnddoc", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@doccod", doccod);
SqlDataReader dr = cmd.ExecuteReader();
List <clsdocprp> obj = new List <clsdocprp>();
if (dr.HasRows)
{
dr.Read();
clsdocprp k = new clsdocprp();
k.doccod = Convert.ToInt32(dr[0]);
k.docnam = dr[1].ToString();
k.docarecod = Convert.ToInt32(dr[2]);
k.docspccod = Convert.ToInt32(dr[3]);
k.docprf = dr[4].ToString();
k.docqal = dr[5].ToString();
k.docpic = dr[6].ToString();
k.docadd = dr[7].ToString();
k.docavltim = dr[8].ToString();
k.docappphn = dr[9].ToString();
k.docusrcod = Convert.ToInt32(dr[10]);
obj.Add(k);
}
dr.Close();
cmd.Dispose();
con.Close();
return(obj);
}
public List <clsdocprp> Disp_Rec()
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("dspdoc", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = cmd.ExecuteReader();
List <clsdocprp> obj = new List <clsdocprp>();
while (dr.Read())
{
clsdocprp k = new clsdocprp();
k.doccod = Convert.ToInt32(dr[0]);
k.docnam = dr[1].ToString();
k.docarecod = Convert.ToInt32(dr[2]);
k.docspccod = Convert.ToInt32(dr[3]);
k.docprf = dr[4].ToString();
k.docqal = dr[5].ToString();
k.docpic = dr[6].ToString();
k.docadd = dr[7].ToString();
k.docavltim = dr[8].ToString();
k.docappphn = dr[9].ToString();
k.docusrcod = Convert.ToInt32(dr[10]);
obj.Add(k);
}
dr.Close();
cmd.Dispose();
con.Close();
return(obj);
}
protected void Button1_Click(object sender, EventArgs e)
{
// 1) insert record to tbusr
nsgetwell.clsusr obj = new nsgetwell.clsusr();
nsgetwell.clsusrprp objprp = new nsgetwell.clsusrprp();
objprp.usreml = TextBox2.Text;
objprp.usrphn = TextBox3.Text;
objprp.usrregdat = DateTime.Now;
objprp.usrrol = 'D';
String pwd = Guid.NewGuid().ToString();
pwd = pwd.Substring(0, 10);
objprp.usrpwd = pwd;
Int32 a = obj.Save_Rec(objprp);
// 2) fetch usrcod and insert partial details to tbdoc
nsgetwell.clsdoc obj1 = new nsgetwell.clsdoc();
nsgetwell.clsdocprp objprp1 = new nsgetwell.clsdocprp();
objprp1.docnam = TextBox1.Text;
objprp1.docarecod = Convert.ToInt32(DropDownList2.SelectedValue);
objprp1.docspccod = Convert.ToInt32(DropDownList3.SelectedValue);
objprp1.docusrcod = a;
obj1.Save_Rec(objprp1);
// 3) send email to doctor containing login info
String bdy = "<a href=index.aspx> Click Here</a> to login to your account." +
"<b>Email:</b>" + TextBox2.Text + "<br><b>Password:</b> " + pwd;
MailMessage mm = new MailMessage("*****@*****.**", TextBox2.Text,
"Login Information", bdy);
mm.IsBodyHtml = true;
SmtpClient c = new SmtpClient("mail.connectzone.in", 25);
c.Send(mm);
Response.Redirect("frmdoc.aspx");
}
protected void Button1_Click(object sender, EventArgs e)
{
nsgetwell.clsdoc obj = new nsgetwell.clsdoc();
nsgetwell.clsdocprp objprp = new nsgetwell.clsdocprp();
objprp.docadd = txtadd.Text;
objprp.docaddcrd = Hidden1.Value;
objprp.docappphn = txtphn.Text;
objprp.docavltim = txtavltim.Text;
objprp.doccod = Convert.ToInt32(Session["cod"]);
objprp.docprf = Editor1.Content;
objprp.docqal = txtqal.Text;
String s = FileUpload1.PostedFile.FileName;
if (s != "")
{
s = s.Substring(s.LastIndexOf("."));
objprp.docpic = s;
}
else
{
objprp.docpic = ViewState["pic"].ToString();
}
obj.Update_Rec(objprp);
if (s != "")
{
FileUpload1.PostedFile.SaveAs(Server.MapPath("../docpics") + "//" +
Session["cod"].ToString() + s);
}
}
public void Delete_Rec(clsdocprp p)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("deldoc", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@doccod", p.doccod);
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
}
public void Update_Rec(clsdocprp p)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("upddoc", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@doccod", p.doccod);
cmd.Parameters.AddWithValue("@docprf", p.docprf);
cmd.Parameters.AddWithValue("@docqal", p.docqal);
cmd.Parameters.AddWithValue("@docpic", p.docpic);
cmd.Parameters.AddWithValue("@docadd", p.docadd);
cmd.Parameters.AddWithValue("@docavltim", p.docavltim);
cmd.Parameters.AddWithValue("@docappphn", p.docappphn);
cmd.Parameters.AddWithValue("@docaddcrd", p.docaddcrd);
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
}
