DEV Community: harsh123

How to send email in .NET

harsh123 — Sun, 08 May 2022 17:34:14 +0000

Email.cs

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

namespace email_sending
{
    public partial class email : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void send_Click(object sender, EventArgs e)
        {
            try
            {
                MailMessage message = new MailMessage();
                SmtpClient smpt = new SmtpClient();
                message.From = new MailAddress("Enter Your Email Here");
                message.To.Add(new MailAddress(to.Text));
                message.Subject = "Testing";
                message.IsBodyHtml = true;
                message.Body = body.Text;
                smpt.Port = 587;
                smpt.Host = "smtp.office365.com";
                smpt.EnableSsl = true;
                smpt.UseDefaultCredentials = false;
                smpt.Credentials = new NetworkCredential("Enter Your Email Here", "Enter Your Passwrod");
                smpt.DeliveryMethod = SmtpDeliveryMethod.Network;
                smpt.Send(message);
            } catch (Exception ex)
            {

            }
        }
    }
}

Folder Structure

How to make login in .NET

harsh123 — Sun, 08 May 2022 17:27:26 +0000

Login.cs

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

namespace login
{
    public partial class login : System.Web.UI.Page
    {
        public object LoginStatus1 { get; private set; }

        protected void Page_Load(object sender, EventArgs e)
        {
            if (IsPostBack) 
            {
                int ViewstateVal = 1;


                if (ViewState["count"] != null)
                {
                    ViewstateVal = Convert.ToInt32(ViewState["count"]) + 1;

                    ViewState["count"] = ViewstateVal.ToString();
                }
                else { ViewState["count"] = "1"; }

                TextBox1.Text = ViewstateVal.ToString();
                ViewState["count"] = ViewstateVal.ToString();
            }

        }

        protected void Login1_Authenticate(object sender, AuthenticateEventArgs e)
        {
            bool verify = false;
            verify = MyAuthenticationLogic(Login1.UserName, Login1.Password);
            e.Authenticated = verify;
            if (e.Authenticated == true)
            {

                HttpCookie c1 = new HttpCookie("loginInfo");
                c1["Name"] = Login1.UserName;
                c1["Password"] = Login1.Password;
                Response.Cookies.Add(c1);

                Server.Transfer("redirect.aspx?username=" + Login1.UserName + "&password=" + Login1.Password, true);
            }
            else{ 
                errMsg.LoginText = "Enter the correct Credentials"; 
            }
        }
        protected bool MyAuthenticationLogic(string username, string password)
        {
            if (username == "Hrushikesh" && password == "CodeMaster")
            {
                return true;
            }
            else
            {
                return false;
            }
        }

        protected void btn1_Click(object sender, EventArgs e)
        {
            Server.Transfer("redirect.aspx?username=" + Login1.UserName + "&password=" + Login1.Password, false);
        }
    }

}

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

namespace login
{
    public partial class redirect : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            string username = Request.QueryString["Username"];
            string password = Request.QueryString["password"];

            msgTxt.Text = "Welcome " + username + " Your Password is : " + password;

            HttpCookie c1 = Request.Cookies["loginInfo"];
            lbl1.Text ="Passord Is : "+ c1["Password"];
        }
    }
}

ScreenShots

How To API in .NET

harsh123 — Sun, 08 May 2022 17:20:52 +0000

PersonController

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using PersonAPI.Models;

using System.Web.Http;

namespace PersonAPI.Controllers
{
    public class PersonController : ApiController
    {
        DB DBlayer = new DB();

        string message = string.Empty;
        // GET: Person


        public IEnumerable<string> Get()
        {
            return new string[] { "value1", "value2" };
        }

        [System.Web.Http.HttpGet]

        public DataSet GetRecord(int id)
        {
            DataSet ds = DBlayer.GetRecordbyID(id, out message);
            return ds;
        }

        [System.Web.Http.HttpPost]
        public string PostCreatePerson([FromBody] PersonModel person)
        {
            string message = "";
            message = DBlayer.InsertPerson(person);
            return message;
        }

        [System.Web.Http.HttpPut]

        public string PutUpdatePerson(int id, [FromBody] PersonModel person) 
        {
            string message = "";
            message = DBlayer.UpdatePerson(person);
            return message;
        }

        [System.Web.Http.HttpDelete]

        public string DeletePerson(int id)
        {
            string message = "";
            message = DBlayer.DeletePerson(id);
            return message;
        }
    }
}

DB.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.SqlClient;
using System.Data;
using PersonAPI.Models;

namespace PersonAPI
{
    public class DB
    {
        public SqlConnection ConnecttoDB()
        {
            string connectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename='D:\NUV\Second Year\Sem 4\ASP.NET\PersonAPI\PersonAPI\App_Data\Person.mdf';Integrated Security=True";
            SqlConnection con = new SqlConnection(connectionString);
            con.Open();
            return con;

        }

        public DataSet GetRecordbyID(int id, out string message)
        {
            message = "";
            SqlConnection con = ConnecttoDB();
            SqlCommand com = new SqlCommand("getPersonbyID", con);
            com.CommandType = System.Data.CommandType.StoredProcedure;
            com.Parameters.AddWithValue("@id", id);

            SqlDataAdapter adp = new SqlDataAdapter(com);
            DataSet ds = new DataSet();
            adp.Fill(ds);

            return ds;
            con.Close();
            message = "Success";
        }

        public string InsertPerson(PersonModel person)
        {
            string message = "";
            SqlConnection con = ConnecttoDB();
            SqlCommand com = new SqlCommand("gpInsertPerson", con);
            com.CommandType = CommandType.StoredProcedure;

            com.Parameters.AddWithValue("@id", person.id);
            com.Parameters.AddWithValue("@Name", person.Name);
            com.Parameters.AddWithValue("@City", person.City);
            com.Parameters.AddWithValue("@Phoneno", person.phoneno);

            com.ExecuteNonQuery();
            message = "Success";
            return message;

        }

        public string UpdatePerson(PersonModel person)
        {
            string message = "";
            SqlConnection con = ConnecttoDB();
            SqlCommand com = new SqlCommand("gpUpdatePerson", con);
            com.CommandType = CommandType.StoredProcedure;

            com.Parameters.AddWithValue("@id", person.id);
            com.Parameters.AddWithValue("@Name", person.Name);
            com.Parameters.AddWithValue("@City", person.City);
            com.Parameters.AddWithValue("@Phoneno", person.phoneno);

            com.ExecuteNonQuery();
            message = "Success";
            return message;

        }

        public string DeletePerson(int id)
        {
            string message = "";
            SqlConnection con = ConnecttoDB();
            SqlCommand com = new SqlCommand("spDeletePerson", con);
            com.CommandType = CommandType.StoredProcedure;

            com.Parameters.AddWithValue("@id", id);


            com.ExecuteNonQuery();
            message = "Success";
            return message;

        }

    }

}

Model

public int id { get; set; }

public string Name { get; set; }

public string City { get; set; }

public string phoneno { get; set; }

Store Procedure

Delete Person

CREATE PROCEDURE [dbo].[DeletePerson]
    @id int
AS
BEGIN
    delete from Person where Id = @id;
END;

Insert

CREATE PROCEDURE [dbo].[getInsertPerson]
    @id int,
    @name varchar(50),
    @city varchar(50),
    @phone nvarchar(50)
AS
BEGIN
    insert into Person (ID, Name, City, Phone) values (@id,@name, @city, @phone);
END;

getPerson

CREATE PROCEDURE [dbo].[getPerson]

AS
BEGIN
    SELECT * from Person
END;

getPersonID

CREATE PROCEDURE [dbo].[getPerson]

AS
BEGIN
    SELECT * from Person
END;

update person

CREATE PROCEDURE [dbo].[getUpdatePersonn]
    @id int,
    @name varchar(50),
    @city varchar(50),
    @phone nvarchar(50)
AS
BEGIN
    Update Person set Name = @name, City = @city, Phone = @phone where Id = @id
END