Saturday 28 July 2012

asp.net fastest store procedure class data insert and pic by fast way


using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

public partial class RegistrationUpdate : System.Web.UI.Page
{
    dataUtility appReg = new dataUtility();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            regMstData();
        }

    }
    private DataTable OpenTable(string cExpr, string cWhere)
    {
        string cExcute = "";
        DataTable _tConfE = new DataTable();
        switch (cExpr)
        {
            case "Varify"://---varify email 0->1 taken reg mst data
                cExcute = "Exec sp_register 2, '" + cWhere + "'";
                break;
            default:
                break;
        }
        if (!string.IsNullOrEmpty(cExcute))
        {
            _tConfE = appReg.executeStoteProc(cExcute);
        }
        return _tConfE;
    }

    private void regMstData()
    {
        string cConReg = Request.QueryString["confirm"].ToString();
        DataTable _tRegMst = OpenTable("Varify", cConReg.Trim());//--after do check already confirm
        RegMstlbl(_tRegMst);//--label text fill
    }
    private void RegMstlbl(DataTable tRegMst)
    {//-- label value data souce value from table
        foreach (DataRow _dr in tRegMst.Rows)
        {
            lblUserName.Text=(_dr["first_name"]+ " "+_dr["last_name"]).ToString();
            lblDbo.Text = (_dr["date_of_birth"]).ToString();
            lblGender.Text = (_dr["gender"]).ToString();
            lblEmail.Text = (_dr["email"]).ToString();
            lblVarify.Text = (_dr["varify"]).ToString();
            lblrow_id.Text = (_dr["row_id"]).ToString();
        }
    }
}
//----------------

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.Net.Mail;

public partial class registration : System.Web.UI.Page
{
    dataUtility appReg = new dataUtility();
    protected void Page_Load(object sender, EventArgs e)
    {
       

    }
 
    private void SaveRegistration()
    {
        SqlParameter[] par = new SqlParameter[6];
        par[0] = appReg.addPara("@first", SqlDbType.VarChar, txtfName.Text.Trim().ToString());
        par[1] = appReg.addPara("@last", SqlDbType.VarChar, txtlName.Text.Trim().ToString());
        par[2] = appReg.addPara("@date_of_birth", SqlDbType.Date, txtDob.Text.Trim().ToString());
        par[3] = appReg.addPara("@gender", SqlDbType.NChar, txtGender.Text.Trim().ToString());
        par[4] = appReg.addPara("@email", SqlDbType.VarChar, txtEmail.Text.Trim().ToString());
        par[5] = appReg.addPara("@password", SqlDbType.VarChar, txtPassword.Text.Trim().ToString());

        appReg.insStoreProc("sp_registration_save", par);//---store proc save data in registrationMst/ login
        SendMail(txtEmail.Text.Trim().ToString());

        lblMsg.Text = "Registration Successfully Create. Go to Mail and Confirm your account Information";
    }
    private void SendMail(string email)
    {//--send email and confirm mgs 
        string _conf = confirmEmail();//=== confirm code
        string strMsgBody = "<table style='width: 702px; border-raduis:5px; background-color:#b6776; color:Gray; height: 200px;'><tbody>" +
                    "<tr> <td width='100'>Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;     :</td><td>" + txtfName.Text.Trim().ToString() + " " + txtlName.Text.Trim().ToString() + "</td></tr>" +
                   "<tr> <td>Email id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :</td><td>" + txtEmail.Text.Trim() + "</td></tr>" +
                    "<tr> <td>password&nbsp;&nbsp; :</td><td>" + txtPassword.Text.Trim() + "</td></tr>" +
                    "<tr> <td>&nbsp;</td><td>please link blow for confirmation of your account</td></tr>" +
                    "<tr> <td>&nbsp;</td><td>" + _conf + "</td></tr>" +
                    "<tr> <td>&nbsp;</td><td>&nbsp;</td></tr>"+
                    "<tr> <td>&nbsp;</td><td>more information go to <a href='http://zerodegreeentertainment.in/' target='_blank'>http://zerodegreeentertainment.in </a> </td></tr>"+
                    "</tbody></table>";
            MailAddress SendFrom = new MailAddress("********");
            MailAddress SendTo = new MailAddress(email);
            MailMessage MyMessage = new MailMessage(SendFrom, SendTo);
            MyMessage.IsBodyHtml = true;
            MyMessage.Subject = "confirm Registration of zerodegree";
            MyMessage.Body = strMsgBody;
            System.Net.NetworkCredential authentication = new System.Net.NetworkCredential("*******", "*********");
            SmtpClient client = new SmtpClient("smtp.gmail.com", 25);
            client.EnableSsl = true;
            client.UseDefaultCredentials = true;
            client.Credentials = authentication;
            client.Send(MyMessage);
             
    }
    protected void ImageButton1_Click1(object sender, ImageClickEventArgs e)
    {
        //-- registration submit
        SaveRegistration();

    }
    private DataTable OpenTable(string cExpr, string cWhere)
    {
        string cExcute = "";
        DataTable _tConfE = new DataTable();
        switch (cExpr)
        {
            case "ConfirmRow":
                cExcute = "Exec sp_register 1, '" + cWhere + "'";
                break;
            default:
                break;
        }
        if (!string.IsNullOrEmpty(cExcute))
        {
           _tConfE= appReg.executeStoteProc(cExcute);
        }
        return _tConfE;
    }
    private string confirmEmail()
    {
        string cConfirmE = null;
        DataTable tConfE = OpenTable("ConfirmRow",txtEmail.Text.Trim().ToString());
        if (tConfE.Rows.Count>0)
        {
            cConfirmE = "http://zerodegreeentertainment.in/RegistrationUpdate.aspx?confirm=";
            cConfirmE += tConfE.Rows[0][0].ToString();
        }
        return cConfirmE;
    }
}

No comments:

Post a Comment