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(); }