Asp.Net

Tuesday 27 August 2013

simple mail send

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Net;

public partial class Email : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        SendMailtoEmployee();

    }
    public void SendMailtoEmployee()
    {
        var fromAddress = "naveenkc2@gmail.com";

        var toAddress = "naveenkc2@gmail.com";

        const string fromPassword = "naveenkc@kit";

        string subject = "Hi! Mail From Dialಮಾಡಿ.com, Your Login Details";

        string body = "  WelCome to Dialಮಾಡಿ.com";

        var smtp = new System.Net.Mail.SmtpClient();
        {
            smtp.Host = "smtp.gmail.com";
            smtp.Port = 587;
            smtp.EnableSsl = true;
            smtp.DeliveryMethod = System.Net.Mail.SmtpDeliveryMethod.Network;
            smtp.Credentials = new NetworkCredential(fromAddress, fromPassword);
            smtp.Timeout = 20000;
        }
        smtp.Send(fromAddress, toAddress, subject, body);
    }
}

password recovery

aspx page
<div style="height: 800px; width: 800px; vertical-align: middle;">
        <br />
        <br />
        <br />
        <br />
        <br />
        <br />
        <center>
            <asp:Panel ID="panel1" runat="server">
                <table>
                    <tr>
                        <td>
                            <asp:Label ID="EmailLabel" runat="server">E-Mail Id:</asp:Label>
                        </td>
                        <td>
                            <asp:TextBox ID="txtEmail" runat="server" CssClass="{txtcurcomp:true,textEntry}"
                                Height="25px" BorderColor="#666666" BorderStyle="Solid" BorderWidth="1px" Font-Size="Medium"
                                Width="300px"></asp:TextBox>
                            <asp:RequiredFieldValidator ID="EmailRequired" runat="server" ControlToValidate="txtEmail"
                                CssClass="failureNotification" ErrorMessage="E-mail is required." ToolTip="E-mail is required."
                                ValidationGroup="l1">*</asp:RequiredFieldValidator>
                        </td>
                    </tr>
                    <tr id="tr1" runat="server" visible="false">
                        <td align="right">
                            <asp:Label ID="Label1" runat="server">Username:</asp:Label>
                        </td>
                        <td align="left">
                            <asp:TextBox ID="txtUsername" runat="server" BorderColor="#666666" BorderStyle="Solid"
                                BorderWidth="1px"></asp:TextBox>
                        </td>
                    </tr>
                    <tr id="tr2" runat="server" visible="false">
                        <td align="right">
                            <asp:Label ID="Label2" runat="server">Password:</asp:Label>
                        </td>
                        <td align="left">
                            <asp:TextBox ID="txtPassword" runat="server" BorderColor="#666666" BorderStyle="Solid"
                                BorderWidth="1px"></asp:TextBox>
                        </td>
                    </tr>
                    <tr>
                        <td>
                        </td>
                        <td align="left">
                            <asp:Button ID="btnSubmit" runat="server" Text="Submit" ValidationGroup="l1" Height="28px"
                                Width="100px" OnClick="btnSubmit_Click" />
                        </td>
                    </tr>
                    <tr>
                        <td>
                        </td>
                        <td>
                            Try&nbsp;&nbsp;<asp:LinkButton ID="LinkButton1" runat="server" PostBackUrl="~/AgentLogin.aspx">Login</asp:LinkButton>
                            &nbsp;Again
                        </td>
                    </tr>
                </table>
                <p style="margin-left: 200px; font-family: Cambria; font-size: medium; font-weight: bold;">
                    <asp:Label ID="lblmsg" runat="server" ForeColor="Green" />
                    <asp:Label ID="lblerrmsg" runat="server" ForeColor="Red" />
                </p>
            </asp:Panel>
        </center>
    </div>

passwod recovery from email code

 aspx.cs page
protected void SendMailtoEmployee()
    {
        var fromAddress = "ekanathareddy@suviva.net";

        var toAddress = txtEmail.Text.ToString();

        const string fromPassword = "suviva123";

        string subject = "Hi! Mail From Dialಮಾಡಿ.com, Your Login Details";

        string body = "  WelCome to Dialಮಾಡಿ.com. Your Login Details are Username is :" + txtUsername.Text + " and Password is :" + txtPassword.Text + "";

        var smtp = new System.Net.Mail.SmtpClient();
        {
            smtp.Host = "smtp.gmail.com";
            smtp.Port = 587;
            smtp.EnableSsl = true;
            smtp.DeliveryMethod = System.Net.Mail.SmtpDeliveryMethod.Network;
            smtp.Credentials = new NetworkCredential(fromAddress, fromPassword);
            smtp.Timeout = 20000;
        }
        smtp.Send(fromAddress, toAddress, subject, body);
    }
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        try
        {
            ds = bal.ForgottenPassword(txtEmail.Text);
            if (ds.Tables.Count > 0)
            {
                if (ds.Tables[0].Rows.Count > 0)
                {
                    txtUsername.Text = ds.Tables[0].Rows[0][0].ToString();
                    txtPassword.Text = ds.Tables[0].Rows[0][1].ToString();
                    SendMailtoEmployee();
                    lblmsg.Text = "Your Login Details has been sent to Your Mail Id Successfully...";
                    txtEmail.Text = string.Empty;
                }

            }
            else
                lblerrmsg.Text = "Deatails was not found.";

        }
        catch (Exception ex)
        {
            lblerrmsg.Text = ex.Message;
        }
    }

Tuesday 20 August 2013

web config file

For Isolated system:
<connectionStrings>
    <add name="Healthtips" connectionString="Data Source=.; Integrated Security=True; Initial Catalog=Healthtips" providerName="System.Data.Sqlclient"/>
   
   
   
   
  </connectionStrings>
For Server system:
<connectionStrings>
        <add name="SuvivaFreeDialConnectionString" connectionString="Data Source=MAIN;Initial Catalog=freedail;Persist Security Info=True;User ID=sa;Password=123" providerName="System.Data.SqlClient"/>
    </connectionStrings>

DAL Page

public bool logincheck(string str, SqlParameter[] param)
    {
        try
        {
            con.Open();
            cmd = new SqlCommand(str, con);
            cmd.CommandType = CommandType.StoredProcedure;
            foreach (SqlParameter par in param)
            {
                cmd.Parameters.Add(par);
            }
            dr = cmd.ExecuteReader();
            if (dr.HasRows)
            {
                return true;
            }
            else
            {
                return false;
            }

        }
        catch (Exception ex)
        {
            throw ex;
        }
        finally
        {
            con.Close();
        }
       
    }
    public bool createusers(string str, SqlParameter[] param)
    {
        try
        {
            con.Open();
            cmd = new SqlCommand(str, con);
            cmd.CommandType = CommandType.StoredProcedure;
            foreach (SqlParameter par in param)
            {
                cmd.Parameters.Add(par);
            }
            string user = Convert.ToString(cmd.ExecuteNonQuery());
            if (user.Length > 0)
            {
                return true;
            }
            else
            {
                return false;
            }

        }
        catch (Exception ex)
        {
            throw ex;
        }
        finally
        {
            con.Close();
        }
    }
    public DataSet getusers(string str, SqlParameter[] param)
    {
        try
        {
            con.Open();
            cmd = new SqlCommand(str, con);
            cmd.CommandType = CommandType.StoredProcedure;
            foreach (SqlParameter par in param)
            {

                cmd.Parameters.Add(par);
            }
            da.SelectCommand = cmd;
            da.Fill(ds);
            return ds;



        }
        catch (Exception ex)
        {
            throw ex;
        }
        finally
        {
            con.Close();
        }

BAL

BAL Page:
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["Healthtips"].ToString());
    DAL dal = new DAL();
    DataSet ds = new DataSet();
    DataSet ds1 = new DataSet();
public bool logincheck(string username, string password)
    {
        try
        {
            string str = "Sp_Logincheck";
            SqlParameter[] par = new SqlParameter[2];
            par[0] = new SqlParameter("@Username", username);
            par[1] = new SqlParameter("@Password", password);
            if (dal.logincheck(str, par))
            {
                return true;

            }
            else
            {
                return false;
            }

        }
        catch (Exception ex)
        {
            throw ex;
        }
    }
    public bool createusers(string userid, string name, string phonenumber, string email, string username, string password, string city, string state, string country, string gender)
    {
        try
        {
            string str = "Sp_Insertusers";
            SqlParameter[] par = new SqlParameter[10];
            par[0] = new SqlParameter("@User_Id", userid);
            par[1] = new SqlParameter("@Name",name);
            par[2] = new SqlParameter("@Phonenumber",phonenumber);
            par[3] = new SqlParameter("@Email_Id",email);
            par[4] = new SqlParameter("@Username",username);
            par[5] = new SqlParameter("@Password",password);
            par[6] = new SqlParameter("@City",city);
            par[7] = new SqlParameter("@State",state);
            par[8] = new SqlParameter("@Country",country);
            par[9] = new SqlParameter("@Gender",gender);
            if (dal.createusers(str, par))
            {
                return true;
            }
            else
            {
                return false;
            }


        }
        catch (Exception ex)
        {
            throw ex;
        }
    }

Gridview edit delete cs page

default.aspx.cs page:
using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

public partial class Admin_Updatedoctors : System.Web.UI.Page
{
    BAL bal = new BAL();
    DataSet ds = new DataSet();
    protected void Page_Load(object sender, EventArgs e)
    {
        Binddata();
    }
    protected void Binddata()
    {
        try
        {
            ds = bal.getdoctors();
            gvdisplay.DataSource = ds;
            gvdisplay.DataBind();

        }
        catch (Exception ex)
        {
            lblerrmsg.Text = ex.Message;
        }
    }
    protected void gvdisplay_Click(object sender, GridViewCommandEventArgs e)
    {
        try
        {
            Int64 str = Convert.ToInt64(e.CommandArgument);
            if (e.CommandName == "Eedit")
            {
                ds = bal.getsingledoctor(str);
                txtdoctorid.Text = ds.Tables[0].Rows[0][0].ToString();
                txtname.Text = ds.Tables[0].Rows[0][1].ToString();
                txtspecialisation.Text = ds.Tables[0].Rows[0][2].ToString();
                txtphonenumber.Text = ds.Tables[0].Rows[0][3].ToString();
                txtemail.Text = ds.Tables[0].Rows[0][4].ToString();
                txtcity.Text = ds.Tables[0].Rows[0][5].ToString();
                txtstate.Text = ds.Tables[0].Rows[0][6].ToString();
                txtcountry.Text = ds.Tables[0].Rows[0][7].ToString();
                txtgender.Text = ds.Tables[0].Rows[0][8].ToString();
                updatepnl.Visible = true;

            }
            else
            {
                lblerrmsg.Text = "cant edit";
            }

          

        }
        catch (Exception ex)
        {
            lblerrmsg.Text = ex.Message;
        }

    }
}

Gridview edit delete aspx page

Default.aspx page:
<asp:GridView ID="gvdisplay" runat="server" OnRowCommand="gvdisplay_Click" AutoGenerateColumns="false">
        <Columns>
            <asp:BoundField HeaderText="Doctor_Id" DataField="Doctor_ID" />
            <asp:BoundField HeaderText="Name" DataField="Name" />
            <asp:BoundField HeaderText="Specialisation" DataField="Specialisation" />
            <asp:BoundField HeaderText="Phonenumber" DataField="Phonenumber" />
            <asp:BoundField HeaderText="Email_Id" DataField="Email_ID" />
            <asp:BoundField HeaderText="City" DataField="City" />
            <asp:BoundField HeaderText="State" DataField="State" />
            <asp:BoundField HeaderText="Country" DataField="Country" />
            <asp:BoundField HeaderText="Gender" DataField="Gender" />
            <asp:TemplateField HeaderText="Select Action">
                <ItemTemplate>
                    <asp:LinkButton ID="lnkedit" runat="server" CommandArgument='<%#Bind("Doctor_Id") %>'
                        CommandName="Eedit">edit</asp:LinkButton>
                    <asp:LinkButton ID="lnkdelete" runat="server" CommandArgument='<%#Bind("Doctor_Id") %>'
                        CommandName="Edelete">Delete</asp:LinkButton>
                </ItemTemplate>
            </asp:TemplateField>
        </Columns>
    </asp:GridView>
    <asp:Panel ID="updatepnl" runat="server" Visible="false">
        <table>
            <tr>
                <td>
                    <asp:Label ID="lbldoctorid" runat="server" Text="Doctor id"></asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txtdoctorid" runat="server"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:Label ID="lblname" runat="server" Text="Name"></asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txtname" runat="server"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:Label ID="lblspecialisation" runat="server" Text="Specialisation"></asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txtspecialisation" runat="server"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:Label ID="lblphonenumber" runat="server" Text="phonenumber"></asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txtphonenumber" runat="server"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:Label ID="lblemail" runat="server" Text="Email"></asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txtemail" runat="server"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:Label ID="lblcity" runat="server" Text="City"></asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txtcity" runat="server"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:Label ID="lblstate" runat="server" Text="State"></asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txtstate" runat="server"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:Label ID="lblcountry" runat="server" Text="Country"></asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txtcountry" runat="server"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:Label ID="lblgender" runat="server" Text="Gender"></asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txtgender" runat="server"></asp:TextBox>
                </td>
            </tr>
        </table>
    </asp:Panel>