Skip to main content

Featured post

XM Cloud content sync from prod to uat or UAT to prod step by step

When working with Sitecore, it’s common to need content synchronization across environments. Today, I’ll walk you through the steps to sync content from Production to UAT/TEST and vice versa. Steps to Follow 1. Set Up Your Workspace Create a folder on your computer where you will manage the script files and exported data. Open the folder path in PowerShell to begin scripting. We need to run some scripts in PowerShell to update the folder with the basic requirements for syncing content. PS C:\Soft\ContentSync> dotnet new tool-manifest PS C:\Soft\ContentSync> dotnet nuget add source -n Sitecore https://nuget.sitecore.com/resources/v3/index.json PS C:\Soft\ContentSync> dotnet tool install Sitecore.CLI PS C:\Soft\ContentSync> dotnet sitecore cloud login If the above error occurs, you will need to run a different command to resolve the issue. PS C:\Soft\ContentSync> dotnet sitecore init now, Again run above command to open and authenticate with XM Cloud. It will be there a...

How to create registration page in asp.net mvc ? Insert, Delete, update and select in MVC.



You may learn very easy way to insert delete ,update and select operation in asp.net mvc.
I am going to show you step by step to create a registration page and then do above operation on your project.

Step 1 .                Create a  project by using your visual studio then select asp.net mvc 4 template from listed field of your open window and then select internet application . for more understand see below images step by step to create project.





Step 2.                 Create class name registration by clicking right click on model folder and select add class.
Add some properties inside your class . Please see below syntax in your registration class inside model folder.
public class UserRegistration
    {
        [Key]
        public int userid { get; set; }
        public string username { get; set; }
        public string fname { get; set; }
        public string lname { get; set; }
        public string emailid { get; set; }
        public string password { get; set; }
        public string companyName { get; set; }
        public string MobileNumber { get; set; }
        public string CompanyAddres { get; set; }


    }

Step 3                  Create another class in the same file for connection string . add below code in your created file and inherit DbContext.
public class UsersContext : DbContext
    {
        public DbSet<UserRegistration> Registration { get; set; }
    }
Step 3                  Create connection string in webconfig file by name of above class name which is inherit dbcontext
In connection string add name as UsersContext
<add name=" UsersContext " connectionString="Data Source=Shashi-pc\SQLEXPRESS; Initial Catalog=Recharge; Integrated Security=true" providerName="System.Data.SqlClient"/>


Step  4.                Build the project and then go to add controller.        Add the controller name which you required . and select scaffolding option template from open window and then select model class of your registration which you created earlier.
After that select data context class which you can see above name as UserContext which is inherited DbContext.
         
It will automatic create different file in your view folder to do insert delete, update and select details from your database.
It will create automatic a table in your database.
It will automatic create different action method in yor controller to do insert delete, update and select.



See below code of above activity of controller.

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Entity;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using RechargeApplication.Models;

namespace RechargeApplication.Controllers
{
    public class UserRegistrationController : Controller
    {
        private UsersContext db = new UsersContext();

        //
        // GET: /UserRegistration/

        public ActionResult Index()
        {
            return View(db.Registration.ToList());
        }

        //
        // GET: /UserRegistration/Details/5

        public ActionResult Details(int id = 0)
        {
            UserRegistration userregistration = db.Registration.Find(id);
            if (userregistration == null)
            {
                return HttpNotFound();
            }
            return View(userregistration);
        }

        //
        // GET: /UserRegistration/Create

        public ActionResult Create()
        {
            return View();
        }

        //
        // POST: /UserRegistration/Create

        [HttpPost]
        public ActionResult Create(UserRegistration userregistration)
        {
            if (ModelState.IsValid)
            {
                db.Registration.Add(userregistration);
                db.SaveChanges();
                return RedirectToAction("Index");
            }

            return View(userregistration);
        }

        //
        // GET: /UserRegistration/Edit/5

        public ActionResult Edit(int id = 0)
        {
            UserRegistration userregistration = db.Registration.Find(id);
            if (userregistration == null)
            {
                return HttpNotFound();
            }
            return View(userregistration);
        }

        //
        // POST: /UserRegistration/Edit/5

        [HttpPost]
        public ActionResult Edit(UserRegistration userregistration)
        {
            if (ModelState.IsValid)
            {
                db.Entry(userregistration).State = EntityState.Modified;
                db.SaveChanges();
                return RedirectToAction("Index");
            }
            return View(userregistration);
        }

        //
        // GET: /UserRegistration/Delete/5

        public ActionResult Delete(int id = 0)
        {
            UserRegistration userregistration = db.Registration.Find(id);
            if (userregistration == null)
            {
                return HttpNotFound();
            }
            return View(userregistration);
        }

        //
        // POST: /UserRegistration/Delete/5

        [HttpPost, ActionName("Delete")]
        public ActionResult DeleteConfirmed(int id)
        {
            UserRegistration userregistration = db.Registration.Find(id);
            db.Registration.Remove(userregistration);
            db.SaveChanges();
            return RedirectToAction("Index");
        }

        protected override void Dispose(bool disposing)
        {
            db.Dispose();
            base.Dispose(disposing);
        }
    }
}

  



Comments