DOTNET POINT: CRUD operations using CORE(2.1) MVC6 ,Generic Repository & Dependency Injection, EF code first approach , jquery datatable, jquery datepicker, multiselect dropdown.

Models :

using System;

using System.Collections.Generic;

using System.Linq;

using System.Threading.Tasks;

using System.ComponentModel.DataAnnotations;

namespace WebApplication1.Models

{

public class COUNTRY

{

[Key]

public int CID { get; set; }

[MaxLength(50)]

public string CNAME { get; set; }

}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Threading.Tasks;

using System.ComponentModel.DataAnnotations;

namespace WebApplication1.Models

{

public class STATE

{

[Key]

public int SID { get; set; }

[MaxLength(50)]

public string SNAME { get; set; }

public int CID { get; set; }

}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Threading.Tasks;

using System.ComponentModel.DataAnnotations;

namespace WebApplication1.Models

{

public class HOBBY

{

[Key]

public int HID { get; set; }

public string DNAME { get; set; }

}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Threading.Tasks;

using System.ComponentModel.DataAnnotations;

namespace WebApplication1.Models

{

public class HMAP

{

[Key]

public int ID { get; set; }

public int CID { get; set; }

public int HID { get; set; }

}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Threading.Tasks;

using System.ComponentModel.DataAnnotations;

namespace WebApplication1.Models

{

public class INTEREST

{

[Key]

public int IID { get; set; }

public string INAME { get; set; }

}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Threading.Tasks;

using System.ComponentModel.DataAnnotations;

namespace WebApplication1.Models

{

public class IMAP

{

[Key]

public int ID { get; set; }

public int CID { get; set; }

public int IID { get; set; }

}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Threading.Tasks;

using System.ComponentModel.DataAnnotations;

using System.ComponentModel.DataAnnotations.Schema;

namespace WebApplication1.Models

{

public class CUSTOMER

{

[Key, DatabaseGenerated(DatabaseGeneratedOption.None)]

public int EID { get; set; }

[MaxLength(50)]

public string NAME { get; set; }

public string ADDRESS { get; set; }

[MaxLength(50)]

public string PASSWORD { get; set; }

[MaxLength(50)]

public string GENDER { get; set; }

[MaxLength(50)]

public string EMAIL { get; set; }

public decimal SALARY { get; set; }

public DateTime DOJ { get; set; }

public string PATH { get; set; }

public int CID { get; set; }

public int SID { get; set; }

}

View Model:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Threading.Tasks;

using System.ComponentModel.DataAnnotations;

using Microsoft.AspNetCore.Mvc.Rendering;

using Microsoft.AspNetCore.Http;

using Microsoft.AspNetCore.Mvc;

namespace WebApplication1.Models

{

public class CUSTOMERVM

{

public CUSTOMERVM()

{

HOBBY = new List<SelectListItem>();

LCID = new List<SelectListItem>();

LSID = new List<SelectListItem>();

INTEREST = new List<string>();

LINTEREST = new List<SelectListItem>();

}

[Required(ErrorMessage = "Eid should not be blank.")]

public int? EID { get; set; }

[Required(ErrorMessage ="Name should not be blank.")]

public string NAME { get; set; }

[Required(ErrorMessage = "Address should not be blank.")]

[DataType(DataType.MultilineText)]

public string ADDRESS { get; set; }

[Required(ErrorMessage = "Password should not be blank.")]

[StringLength(8,MinimumLength =6,ErrorMessage ="Password length between 6 to 8 charecters long.")]

[DataType(DataType.Password)]

public string PASSWORD { get; set; }

[DataType(DataType.Password)]

[Display(Name ="CONFIRM PASSWORD")]

[Required(ErrorMessage = "Confirm password should not be blank.")]

[Compare("PASSWORD",ErrorMessage ="Password and confirm password must be same.")]

public string CPASSWORD { get; set; }

[Required(ErrorMessage = "Please select a gender.")]

public string GENDER { get; set; }

[Required(ErrorMessage = "Email should not be blank.")]

[Remote("Check","Custom",ErrorMessage = "This mail id is already exists")]

[RegularExpression(@"\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*", ErrorMessage ="Invalid email id.")]

public string EMAIL { get; set; }

[Required(ErrorMessage = "Salary should not be blank.")]

[Range(5000,500000,ErrorMessage ="Salary range between 5000 to 500000.")]

public decimal SALARY { get; set; }

[Required(ErrorMessage = "Doj should not be blank.")]

public DateTime DOJ { get; set; }

[Cheboxsvalidation(ErrorMessage ="Please select a hobby.")]

public List<SelectListItem> HOBBY { get; set; }

[Required(ErrorMessage = "Please select a country.")]

[Display(Name ="COUNTRY")]

public int CID { get; set; }

public List<SelectListItem> LCID { get; set; }

[Required(ErrorMessage = "Please select a state.")]

public int SID { get; set; }

public List<SelectListItem> LSID { get; set; }

[Listboxvalidation(ErrorMessage = "Please select a interest.")]

public List<string> INTEREST { get; set; }

public List<SelectListItem> LINTEREST { get; set; }

public string PATH { get; set; }

[Required(ErrorMessage = "Please select a photo.")]

public IFormFile PHOTO { get; set; }

}

public class Cheboxsvalidation:ValidationAttribute

{

public override bool IsValid(object value)

{

if (value == null)

return false;

else

return ((List<SelectListItem>)value).Count(m => m.Selected) > 0;

}

public class Listboxvalidation:ValidationAttribute

{

public override bool IsValid(object value)

{

if (value == null)

return false;

else

return ((List<string>)value).Count > 0;

}

Repository :

using System;

using System.Collections.Generic;

using System.Linq;

using System.Threading.Tasks;

using Microsoft.EntityFrameworkCore;

namespace WebApplication1.Models

{

public class Repository<T> : IRepository<T> where T : class

{

private readonly AppDbContext context;

public Repository(AppDbContext Context)

{

this.context = Context;

}

public async Task Delete(int id)

{

var data = await Get(id);

context.Set<T>().Remove(data);

await context.SaveChangesAsync();

}

public async Task Multipledelete(List<T> t)

{

context.Set<T>().RemoveRange(t);

await context.SaveChangesAsync();

}

public async Task<T> Get(int id)

{

return await context.Set<T>().FindAsync(id);

}

public IQueryable<T> Gets()

{

return context.Set<T>().AsNoTracking();

}

public async Task Multiplesave(List<T> t)

{

await context.Set<T>().AddRangeAsync(t);

await context.SaveChangesAsync();

}

public async Task Save(T t)

{

await context.Set<T>().AddAsync(t);

await context.SaveChangesAsync();

}

public async Task Update(T t)

{

context.Set<T>().Update(t);

await context.SaveChangesAsync();

}

Implement Repository :

using System;

using System.Collections.Generic;

using System.Linq;

using System.Threading.Tasks;

using Microsoft.EntityFrameworkCore;

namespace WebApplication1.Models

{

public class Repository<T> : IRepository<T> where T : class

{

private readonly AppDbContext context;

public Repository(AppDbContext Context)

{

this.context = Context;

}

public async Task Delete(int id)

{

var data = await Get(id);

context.Set<T>().Remove(data);

await context.SaveChangesAsync();

}

public async Task Multipledelete(List<T> t)

{

context.Set<T>().RemoveRange(t);

await context.SaveChangesAsync();

}

public async Task<T> Get(int id)

{

return await context.Set<T>().FindAsync(id);

}

public IQueryable<T> Gets()

{

return context.Set<T>().AsNoTracking();

}

public async Task Multiplesave(List<T> t)

{

await context.Set<T>().AddRangeAsync(t);

await context.SaveChangesAsync();

}

public async Task Save(T t)

{

await context.Set<T>().AddAsync(t);

await context.SaveChangesAsync();

}

public async Task Update(T t)

{

context.Set<T>().Update(t);

await context.SaveChangesAsync();

}

DbContext :

using System;

using System.Collections.Generic;

using System.Linq;

using System.Threading.Tasks;

using Microsoft.EntityFrameworkCore;

namespace WebApplication1.Models

{

public class AppDbContext : DbContext

{

public AppDbContext(DbContextOptions<AppDbContext> options):base(options)

{ }

public DbSet<COUNTRY> COUNTRIEs { get; set; }

public DbSet<STATE> STATEs { get; set; }

public DbSet<HOBBY> HOBBY { get; set; }

public DbSet<HMAP> HMAP { get; set; }

public DbSet<INTEREST> INTEREST { get; set; }

public DbSet<IMAP> IMAP { get; set; }

public DbSet<CUSTOMER> CUSTOMER { get; set; }

}

Add connection string in appsettings.json :

{

"Logging": {

"LogLevel": {

"Default": "Warning"

}

"AllowedHosts": "*",

"ConnectionStrings": {

"DBConnection": "server=(localdb)\\MSSQLLocalDB;database=SIVDB;Trusted_Connection=true;MultipleActiveResultSets=True"

}

Register Dependency Injection in dependency container Startup.cs:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Threading.Tasks;

using Microsoft.AspNetCore.Builder;

using Microsoft.AspNetCore.Hosting;

using Microsoft.AspNetCore.Http;

using Microsoft.AspNetCore.HttpsPolicy;

using Microsoft.AspNetCore.Mvc;

using Microsoft.EntityFrameworkCore;

using Microsoft.Extensions.Configuration;

using Microsoft.Extensions.DependencyInjection;

using WebApplication1.Models;

namespace WebApplication1

{

public class Startup

{

public Startup(IConfiguration configuration)

{

Configuration = configuration;

}

public IConfiguration Configuration { get; }

// This method gets called by the runtime. Use this method to add services to the container.

public void ConfigureServices(IServiceCollection services)

{

services.Configure<CookiePolicyOptions>(options =>

{

// This lambda determines whether user consent for non-essential cookies is needed for a given request.

options.CheckConsentNeeded = context => true;

options.MinimumSameSitePolicy = SameSiteMode.None;

});

services.AddMvc();

//services.AddMvc().SetCompatibilityVersion(CompatibilityVersion.Version_2_1);

services.AddDbContextPool<AppDbContext>(options => options.UseSqlServer(Configuration.GetConnectionString("DBConnection")));

services.AddDbContext<AppDbContext>();

services.AddScoped<IRepository<COUNTRY>, Repository<COUNTRY>>();

services.AddScoped<IRepository<STATE>, Repository<STATE>>();

services.AddScoped<IRepository<CUSTOMER>, Repository<CUSTOMER>>();

services.AddScoped<IRepository<HOBBY>, Repository<HOBBY>>();

services.AddScoped<IRepository<HMAP>, Repository<HMAP>>();

services.AddScoped<IRepository<INTEREST>, Repository<INTEREST>>();

services.AddScoped<IRepository<IMAP>, Repository<IMAP>>();

}

// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.

public void Configure(IApplicationBuilder app, IHostingEnvironment env)

{

if (env.IsDevelopment())

{

app.UseDeveloperExceptionPage();

}

else

{

app.UseExceptionHandler("/Home/Error");

app.UseHsts();

}

app.UseHttpsRedirection();

app.UseStaticFiles();

app.UseCookiePolicy();

app.UseMvc(routes =>

{

routes.MapRoute(

name: "default",

template: "{controller=Custom}/{action=Index}/{id?}");

});

}

Use 2 commands for migration :

Add-Migration Intialmigraion

Update-Database

Controller :

using System;

using System.Collections.Generic;

using System.Linq;

using Newtonsoft.Json;

using System.Threading.Tasks;

using Microsoft.AspNetCore.Mvc;

using WebApplication1.Models;

using Microsoft.AspNetCore.Mvc.Rendering;

using System.IO;

using Microsoft.AspNetCore.Hosting;

namespace WebApplication1.Controllers

{

public class CustomController : Controller

{

#region

private readonly IRepository<CUSTOMER> rCUSTOMER;

private readonly IRepository<COUNTRY> rCOUNTRY;

private readonly IRepository<STATE> rSTATE;

private readonly IRepository<HOBBY> rHOBBY;

private readonly IRepository<HMAP> rHMAP;

private readonly IRepository<INTEREST> rINTEREST;

private readonly IRepository<IMAP> rIMAP;

private readonly IHostingEnvironment hostingEnvironment;

#endregion

public CustomController(IRepository<CUSTOMER> RCUSTOMER,

IRepository<COUNTRY> RCOUNTRY,

IRepository<STATE> RSTATE,

IRepository<HOBBY> RHOBBY,

IRepository<HMAP> RHMAP,

IRepository<INTEREST> RINTEREST,

IRepository<IMAP> RIMAP,

IHostingEnvironment HostingEnvironment)

{

this.rCUSTOMER = RCUSTOMER;

this.rCOUNTRY = RCOUNTRY;

this.rSTATE = RSTATE;

this.rHOBBY = RHOBBY;

this.rHMAP = RHMAP;

this.rINTEREST = RINTEREST;

this.rIMAP = RIMAP;

this.hostingEnvironment = HostingEnvironment;

}

[HttpGet]

public IActionResult Index()

{

return View(rCUSTOMER.Gets());

}

[HttpGet]

public JsonResult Fillddl(int CID)

{

return Json(JsonConvert.SerializeObject(rSTATE.Gets().Where(m => m.CID == CID).ToList()));

}

[HttpGet]

public IActionResult Create()

{

CUSTOMERVM vm = new CUSTOMERVM();

vm.HOBBY = rHOBBY.Gets().Select(x => new SelectListItem { Value=x.HID.ToString(), Text=x.DNAME }).ToList();

vm.LCID =rCOUNTRY.Gets().Select(x => new SelectListItem { Value = x.CID.ToString(), Text = x.CNAME }).ToList();

vm.LINTEREST = rINTEREST.Gets().Select(x => new SelectListItem { Value = x.IID.ToString(), Text = x.INAME }).ToList();

return View(vm);

}

[HttpPost]

public IActionResult Create(CUSTOMERVM vm)

{

if (ModelState.IsValid)

{

CUSTOMER cUSTOMER = new CUSTOMER();

cUSTOMER.EID = vm.EID??0;

cUSTOMER.NAME = vm.NAME;

cUSTOMER.ADDRESS = vm.ADDRESS;

cUSTOMER.PASSWORD = vm.PASSWORD;

cUSTOMER.GENDER = vm.GENDER;

cUSTOMER.EMAIL = vm.EMAIL;

cUSTOMER.SALARY = vm.SALARY;

cUSTOMER.DOJ = vm.DOJ;

cUSTOMER.CID = vm.CID;

cUSTOMER.SID = vm.SID;

string uniqueFileName = null;

string filePath = null;

string uploadsFolder = string.Empty;

if (vm.PHOTO != null)

{

uploadsFolder = Path.Combine(hostingEnvironment.WebRootPath, "images");

// To make sure the file name is unique we are appending a new

// GUID value and and an underscore to the file name

uniqueFileName = Guid.NewGuid().ToString() + "_" + vm.PHOTO.FileName;

filePath = Path.Combine(uploadsFolder, uniqueFileName);

// Use CopyTo() method provided by IFormFile interface to

// copy the file to wwwroot/images folder

vm.PHOTO.CopyTo(new FileStream(filePath, FileMode.Create));

}

cUSTOMER.PATH =uniqueFileName;

rCUSTOMER.Save(cUSTOMER);

rHMAP.Multiplesave(vm.HOBBY.Where(n=>n.Selected).Select(x => new HMAP { CID =vm.EID.Value, HID = Convert.ToInt32(x.Value) }).ToList());

rIMAP.Multiplesave(vm.INTEREST.Select(x => new IMAP { CID = vm.EID.Value, IID = Convert.ToInt32(x) }).ToList());

return RedirectToAction("Index");

}

else

{

vm.HOBBY = rHOBBY.Gets().Select(x => new SelectListItem { Value = x.HID.ToString(), Text = x.DNAME }).ToList();

vm.LCID = rCOUNTRY.Gets().Select(x => new SelectListItem { Value = x.CID.ToString(), Text = x.CNAME }).ToList();

vm.LSID = rSTATE.Gets().Where(M => M.CID == vm.CID).Select(x => new SelectListItem { Value = x.SID.ToString(), Text = x.SNAME }).ToList();

vm.LINTEREST = rINTEREST.Gets().Select(x => new SelectListItem { Value = x.IID.ToString(), Text = x.INAME }).ToList();

return View(vm);

}

[HttpGet]

public IActionResult Edit(int id)

{

CUSTOMERVM vm = new CUSTOMERVM();

CUSTOMER cUSTOMER = rCUSTOMER.Get(id).Result;

vm.EID = cUSTOMER.EID;

vm.NAME = cUSTOMER.NAME;

vm.ADDRESS = cUSTOMER.ADDRESS;

vm.GENDER = cUSTOMER.GENDER;

vm.EMAIL = cUSTOMER.EMAIL;

vm.SALARY = cUSTOMER.SALARY;

vm.DOJ = cUSTOMER.DOJ;

vm.CID = cUSTOMER.CID;

vm.SID = cUSTOMER.SID;

vm.LCID = rCOUNTRY.Gets().Select(x => new SelectListItem { Value = x.CID.ToString(), Text = x.CNAME }).ToList();

vm.LSID = rSTATE.Gets().Where(m=>m.CID==vm.CID).Select(x => new SelectListItem { Value = x.SID.ToString(), Text = x.SNAME }).ToList();

vm.LINTEREST = rINTEREST.Gets().Select(x => new SelectListItem { Value = x.IID.ToString(), Text = x.INAME }).ToList();

vm.INTEREST = rIMAP.Gets().Where(n => n.CID == vm.EID).Select(m => m.IID.ToString()).ToList();

List<SelectListItem> hlst = new List<SelectListItem>();

int mark = 0;

var hobby = rHOBBY.Gets().ToList();

var mhobby = rHMAP.Gets().Where(m => m.CID == vm.EID).ToList();

foreach (HOBBY hb in hobby)

{

mark = 0;

foreach (HMAP hm in mhobby)

{

if (hb.HID == hm.HID)

{

mark = 1;

break;

}

if (mark == 1)

hlst.Add(new SelectListItem { Value=hb.HID.ToString(), Text=hb.DNAME, Selected=true });

else

hlst.Add(new SelectListItem { Value = hb.HID.ToString(), Text = hb.DNAME, Selected =false });

}

vm.HOBBY = hlst;

return View(vm);

}

[HttpPost]

public IActionResult Edit(CUSTOMERVM vm)

{

ModelState.Remove("PASSWORD");

ModelState.Remove("CPASSWORD");

ModelState.Remove("PHOTO");

if (ModelState.IsValid)

{

CUSTOMER cUSTOMER = rCUSTOMER.Get(vm.EID.Value).Result;

cUSTOMER.NAME = vm.NAME;

cUSTOMER.ADDRESS = vm.ADDRESS;

cUSTOMER.GENDER = vm.GENDER;

cUSTOMER.EMAIL = vm.EMAIL;

cUSTOMER.SALARY = vm.SALARY;

cUSTOMER.DOJ = vm.DOJ;

cUSTOMER.CID = vm.CID;

cUSTOMER.SID = vm.SID;

string uniqueFileName = null;

string filePath = null;

string uploadsFolder = string.Empty;

if (vm.PHOTO != null)

{

uploadsFolder = Path.Combine(hostingEnvironment.WebRootPath, "images");

// To make sure the file name is unique we are appending a new

// GUID value and and an underscore to the file name

uniqueFileName = Guid.NewGuid().ToString() + "_" + vm.PHOTO.FileName;

filePath = Path.Combine(uploadsFolder, uniqueFileName);

// Use CopyTo() method provided by IFormFile interface to

// copy the file to wwwroot/images folder

vm.PHOTO.CopyTo(new FileStream(filePath, FileMode.Create));

cUSTOMER.PATH = uniqueFileName;

}

var data = rHMAP.Gets().Where(m => m.CID == vm.EID.Value).ToList();

var data1 = rIMAP.Gets().Where(m => m.CID == vm.EID.Value).ToList();

rCUSTOMER.Update(cUSTOMER);

foreach (HMAP hm in data)

rHMAP.Delete(hm.ID);

rHMAP.Multiplesave(vm.HOBBY.Where(n => n.Selected).Select(x => new HMAP { CID = vm.EID.Value, HID = Convert.ToInt32(x.Value) }).ToList());

foreach (IMAP im in data1)

rIMAP.Delete(im.ID);

rIMAP.Multiplesave(vm.INTEREST.Select(x => new IMAP { CID = vm.EID.Value, IID = Convert.ToInt32(x) }).ToList());

return RedirectToAction("Index");

}

else

{

vm.HOBBY = rHOBBY.Gets().Select(x => new SelectListItem { Value = x.HID.ToString(), Text = x.DNAME }).ToList();

vm.LCID = rCOUNTRY.Gets().Select(x => new SelectListItem { Value = x.CID.ToString(), Text = x.CNAME }).ToList();

vm.LSID = rSTATE.Gets().Where(M => M.CID == vm.CID).Select(x => new SelectListItem { Value = x.SID.ToString(), Text = x.SNAME }).ToList();

vm.LINTEREST = rINTEREST.Gets().Select(x => new SelectListItem { Value = x.IID.ToString(), Text = x.INAME }).ToList();

return View(vm);

}

[HttpGet]

public IActionResult Check(string EMAIL)

{

if (EMAIL == null)

return Json(false);

else

return Json(!rCUSTOMER.Gets().Any(m => m.EMAIL == EMAIL));

}

[HttpPost]

public IActionResult DeleteAll(List<int> Lst)

{

rCUSTOMER.Multipledelete(rCUSTOMER.Gets().Where(n=>Lst.Contains(n.EID)).ToList());

rHMAP.Multipledelete(rHMAP.Gets().Where(p=>Lst.Contains(p.CID)).ToList());

rIMAP.Multipledelete(rIMAP.Gets().Where(m=>Lst.Contains(m.CID)).ToList());

return Json("1");

}

[HttpGet]

public IActionResult Delete(int id)

{

var data = rHMAP.Gets().Where(m => m.CID == id).ToList();

var data1 = rIMAP.Gets().Where(m => m.CID == id).ToList();

rCUSTOMER.Delete(id);

foreach (HMAP hm in data)

rHMAP.Delete(hm.ID);

foreach (IMAP im in data1)

rIMAP.Delete(im.ID);

return RedirectToAction("Index");

}

Index View :

@model IEnumerable<CUSTOMER>

ViewData["Title"] = "Index";

}

<a asp-action="Create" class="btn btn-primary" style="width:80px">Create</a>

</p>

<tr>

<th>

</th>

<th>

@Html.DisplayNameFor(model => model.EID)

</th>

<th>

@Html.DisplayNameFor(model => model.NAME)

</th>

<th>

@Html.DisplayNameFor(model => model.ADDRESS)

</th>

<th>

@Html.DisplayNameFor(model => model.GENDER)

</th>

<th>

@Html.DisplayNameFor(model => model.EMAIL)

</th>

<th>

@Html.DisplayNameFor(model => model.SALARY)

</th>

<th>

@Html.DisplayNameFor(model => model.DOJ)

</th>

<th>

PHOTO

</th>

<th>ACTION</th>

</tr>

</thead>

<tbody>

@foreach (var item in Model)

{

<tr>

<td>

</td>

<td>

@Html.DisplayFor(modelItem => item.EID)

</td>

<td>

@Html.DisplayFor(modelItem => item.NAME)

</td>

<td>

@Html.DisplayFor(modelItem => item.ADDRESS)

</td>

<td>

@Html.DisplayFor(modelItem => item.GENDER)

</td>

<td>

@Html.DisplayFor(modelItem => item.EMAIL)

</td>

<td>

@Html.DisplayFor(modelItem => item.SALARY)

</td>

<td>

string s = string.Format("{0:dd-MMM-yy}", item.DOJ);

}

</td>

<td>

string t = "~/images/" + item.PATH;

}

</td>

<td>

@Html.ActionLink("Edit", "Edit", new { id = item.EID }) |

@Html.ActionLink("Delete", "Delete", new { id = item.EID })

</td>

</tr>

}

</tbody>

</table>

</div>

</p>

@section Scripts {

@{await Html.RenderPartialAsync("_ValidationScriptsPartial");}

$(function () {

$('#tb').on("click", ".hcb", function () {

$(".cb").attr("checked", this.checked);

});

$('#tb').on("click", ".cb", function () {

if ($('.cb').length == $('.cb:checked').length)

$(".hcb").attr("checked", true);

else

$(".hcb").attr("checked", false);

});

var table = $("#tb").DataTable({

"order": [[0, "asc"]],

"lengthMenu": [[2, 10, 25, 50, -1], [2, 10, 25, 50, "All"]],

"scroller": true,

"orderClasses": false,

});

$('#btnDel').click(function () {

if ($('#tb').find('.cb:checked').length == 0) {

alert('Please select a item from the list.')

return;

}

var ids = [];

if (confirm('Do you want to delete it ?')) {

$('#tb').find('.cb:checked').each(function (i, j) {

ids.push(j.value);

});

$.ajax({

"url": '@Url.Action("DeleteAll", "Custom")',

type: 'Post',

datatype: 'json',

cache: false,

async: true,

data: { Lst: ids },

success: function (data) {

if (data == 1)

window.location.reload(true);

}

});

}

});

})

</script>

}

Create View :

@model CUSTOMERVM

ViewData["Title"] = "Create";

}

</div>

</div>

</div>

</div>

</div>

<input type="radio" asp-for="GENDER" value="Male" />Male

<input type="radio" asp-for="GENDER" value="Female" />Female

</div>

</div>

</div>

</div>

@for (int i = 0; i < Model.HOBBY.Count(); i++)

{

@Model.HOBBY[i].Text

</label>

}

</div>

<option value="">Select</option>

</select>

</div>

<option value="">Select</option>

</select>

</div>

</div>

</div>

</div>

</form>

</div>

<div>

</div>

@section Scripts {

@{await Html.RenderPartialAsync("_ValidationScriptsPartial");}

$(function () {

$('#DOJ').prop("type", "");

$('#DOJ').val("");

$('#INTEREST').multiselect();

$('#DOJ').datepicker();

$('#CID').change(function () {

$.ajax({

url: '@Url.Action("Fillddl", "Custom")',

data: { CID: $(this).val() },

type: 'GET',

dataType: 'json',

contentType: 'application/json; charset=utf-8',

success: function (result) {

$('#SID').empty();

$('#SID').append("<option value=''>Select</option>");

$.each(JSON.parse(result), function (i, j) {

$('#SID').append("<option value='" + j.SID + "'>" + j.SNAME + "</option>");

});

}

});

</script>

}

Edit View :

@model CUSTOMERVM

ViewData["Title"] = "Edit";

}

</div>

</div>

<input type="radio" asp-for="GENDER" value="Male" />Male

<input type="radio" asp-for="GENDER" value="Female" />Female

</div>

</div>

</div>

</div>

@for (int i = 0; i < Model.HOBBY.Count(); i++)

{

@Model.HOBBY[i].Text

</label>

}

</div>

<option value="">Select</option>

</select>

</div>

<option value="">Select</option>

</select>

</div>

</div>

</div>

</div>

</form>

</div>

<div>

</div>

@section Scripts {

@{await Html.RenderPartialAsync("_ValidationScriptsPartial");}

$(function () {

$("#PHOTO").rules("remove", "required")

$("#EMAIL").rules("remove", "remote")

$('#DOJ').prop("type", "");

$('#INTEREST').multiselect();

$('#DOJ').datepicker();

$('#CID').change(function () {

$.ajax({

url: '@Url.Action("Fillddl", "Custom")',

data: { CID: $(this).val() },

type: 'GET',

dataType: 'json',

contentType: 'application/json; charset=utf-8',

success: function (result) {

$('#SID').empty();

$('#SID').append("<option value=''>Select</option>");

$.each(JSON.parse(result), function (i, j) {

$('#SID').append("<option value='" + j.SID + "'>" + j.SNAME + "</option>");

});

}

});

</script>

}

Layout View :

<!DOCTYPE html>

<html>

<head>

<title>@ViewData["Title"] - WebApplication1</title>

</environment>

asp-fallback-href="~/lib/bootstrap/dist/css/bootstrap.min.css"

asp-fallback-test-class="sr-only" asp-fallback-test-property="position" asp-fallback-test-value="absolute" />

</environment>

</head>

<body>

<span class="sr-only">Toggle navigation</span>

</button>

<a asp-area="" asp-controller="Home" asp-action="Index" class="navbar-brand">WebApplication1</a>

</div>

<li><a asp-area="" asp-controller="Home" asp-action="About">About</a></li>

<li><a asp-area="" asp-controller="Home" asp-action="Contact">Contact</a></li>

</ul>

</div>

</nav>

@RenderBody()

<hr />

</footer>

</div>

</environment>

asp-fallback-src="~/lib/jquery/dist/jquery.min.js"

asp-fallback-test="window.jQuery"

crossorigin="anonymous"

integrity="sha384-tsQFqpEReu7ZLhBV2VZlAu7zcOV+rXbYlF2cqB8txI/8aZajjp4Bqd+V6D5IgvKT">

</script>

asp-fallback-src="~/lib/bootstrap/dist/js/bootstrap.min.js"

asp-fallback-test="window.jQuery && window.jQuery.fn && window.jQuery.fn.modal"

crossorigin="anonymous"

integrity="sha384-aJ21OjlMXNL5UyIl/XNwTMqvzeRMZH2w8c5cRVpzpU8Y5bApTppSuUkhZXN0VxHd">

</script>

</environment>

@RenderSection("Scripts", required: false)

</body>

</html>

How to Save date in MVC6 using jquery:

Controller :

[HttpPost]

public IActionResult Add(JBS vm)

{

JRepository.Save(vm);

return Json("Data Saved.");

}

View :

@model JBSVM;

ViewData["Title"] = "Add";

}

</div>

</div>

</div>

</form>

@section Scripts {

@{await Html.RenderPartialAsync("_ValidationScriptsPartial");}

$('#btn').click(function () {

$.ajax({

"url": '@Url.Action("Add", "Jagannath")',

type: 'Post',

datatype: 'json',

cache: false,

async: true,

data: { JID: $('#eid').val(), NAME: $('#name').val() },

success: function (data) {

alert(data);

window.location.href = "Index";

error: function (t) {

alert(t.responseText);

}

});

})

</script>

}

DOTNET POINT

Monday, 26 August 2019

CRUD operations using CORE(2.1) MVC6 ,Generic Repository & Dependency Injection, EF code first approach , jquery datatable, jquery datepicker, multiselect dropdown.

No comments:

Post a Comment