simple crud without db in mvc4

Question

how can i crud insert delete edit in employee with out creating sql.only mvc.

Manoj Maharana · Answer

In page use this script: in layout:

Manoj Maharana · Answer

Here is the model: public CrudModel() { WorkerList = new List (); } public List WorkerList { get; set; } public int Id { get; set; } public string name { get; set; } public string Email { get; set; } public string Address { get; set; } public string ProfilePic { get; set; } public string Phone { get; set; } public DateTime RegisteredDate { get; set; } public int BUId { get; set; } public string message { get; set; } public string UserName { get; set; }

Manoj Maharana · Answer

Controller is here: public ActionResult WorkerList() { int id = 0; CrudModel model = new CrudModel(); var selectWorker = new List (); var result = obj.fetchlist().Select().ToList(); selectWorker = result.Select(item => { return new CrudModel() { Id = Convert.ToInt32(item.ItemArray[0]) name = Convert.ToString(item.ItemArray[1]) Email = Convert.ToString(item.ItemArray[3]) Phone = Convert.ToString(item.ItemArray[2]) }; }).ToList(); model.WorkerList = selectWorker; model.message = Convert.ToString(TempData[ message ]); return View(model); } public ActionResult AddWorker() { CrudModel model = new CrudModel(); return View(model); } [HttpPost] public ActionResult PostWorker(CrudModel model HttpPostedFileBase UploadFile) { int buid = Convert.ToInt32(Session[ UserId ]); string filename = string.Empty; if (UploadFile != null) { string fileExtension = System.IO.Path.GetExtension(UploadFile.FileName); if (fileExtension == .jpg || fileExtension == .png || fileExtension == .jpeg || fileExtension == .gif ) { string name = string.Empty; string fullPath = Path.Combine(Server.MapPath( ~/Content/images ) UploadFile.FileName); UploadFile.SaveAs(fullPath); filename = UploadFile.FileName; } } var result = obj.InsertWorker(model.name model.Email filename model.Address model.Phone); if (result > 0) { return RedirectToAction( WorkerList ); } return RedirectToAction( WorkerList ); } public ActionResult EditWorker( int id) { CrudModel model = new CrudModel(); var EditList = obj.Fetchcrudbyid(id); model.Id = Convert.ToInt32(EditList.Rows[0][ ID ]); model.name = Convert.ToString(EditList.Rows[0][ Name ]); model.Email = Convert.ToString(EditList.Rows[0][ Email ]); //model.ProfilePic = Convert.ToString(EditList.Rows[0][Profilepic]); //model.Address = Convert.ToString(EditList.Rows[0][Address]); return View(model); } [HttpPost] public ActionResult UpdateWorker(CrudModel model HttpPostedFileBase UploadFile) { if (model.Id > 0) { string filename = string.Empty; if (UploadFile != null) { string fileExtension = System.IO.Path.GetExtension(UploadFile.FileName); if (fileExtension == .jpg || fileExtension == .png || fileExtension == .jpeg || fileExtension == .gif ) { string name = string.Empty; string fullPath = Path.Combine(Server.MapPath( ~/Content/images ) UploadFile.FileName); UploadFile.SaveAs(fullPath); filename = UploadFile.FileName; } } else { filename = model.ProfilePic; } //var result = obj.UpdateWorker(model.Id model.name model.Email filename model.Address // model.Phone model.BUId); } return RedirectToAction( WorkerList ); } public ActionResult DeleteWorker( int id) { //string message = string.Empty; CrudModel model = new CrudModel(); // int EditList = obj.DeltWorker(id); return RedirectToAction( WorkerList ); } BL is here: UserDL obj = new UserDL(); public DataTable fetchlist() { return obj.fetchlist(); } public DataTable Fetchcrudbyid( int id) { return obj.Fetchcrudbyid(id); } public Int32 InsertWorker(string name string Email string profilename string adress string phone) { Int32 retval = obj.SaveWorker(name Email profilename adress phone); return retval; } DL is here: ClsDB objDB = new ClsDB(); public DataTable fetchlist() { try { SqlParameter[] param = new SqlParameter[0]; DataTable dt = objDB.Return_datatable( sp_fetchcrudlist  param); return dt; } catch (Exception ex) { throw ex; } } public DataTable Fetchcrudbyid( int id) { try { SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter( @id  SqlDbType.Int); param[0].Direction = ParameterDirection.Input; param[0].Value = id; DataTable dt = objDB.Return_datatable( fetchbyid  param); return dt; } catch (Exception ex) { throw ex; } } public Int32 SaveWorker(string name string Email string profilename string adress string phone) { try { SqlParameter[] param = new SqlParameter[5]; param[0] = new SqlParameter( @Name  SqlDbType.NVarChar 100); param[0].Direction = ParameterDirection.Input; param[0].Value = name; param[1] = new SqlParameter( @Email  SqlDbType.NVarChar 100); param[1].Direction = ParameterDirection.Input; param[1].Value = Email; param[2] = new SqlParameter( @ProfilePic  SqlDbType.NVarChar 3500); param[2].Direction = ParameterDirection.Input; param[2].Value = profilename; param[3] = new SqlParameter( @Address  SqlDbType.NVarChar 3500); param[3].Direction = ParameterDirection.Input; param[3].Value = adress; param[4] = new SqlParameter( @phone  SqlDbType.NVarChar 20); param[4].Direction = ParameterDirection.Input; param[4].Value = phone; Int32 retval = objDB.insert_delete_update( insertdemo  param); return retval; } catch (Exception ex) { throw ex; } } ClsDb is here: String strcon = Convert.ToString(ConfigurationManager.AppSettings[ ConnectDB ]); SqlConnection con; public void DBconnection() { con = new SqlConnection(strcon); if (con.State == ConnectionState.Closed) { con.Open(); } } public DataTable Return_datatable(string strquery) { DBconnection(); SqlCommand cmd = new SqlCommand(strquery con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); con.Close(); return dt; } public DataTable Return_datatable(String strq SqlParameter[] param) { DBconnection(); SqlCommand cmd = new SqlCommand(strq con); for ( int i = 0; i { cmd.Parameters.Add(param[i]); } cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); con.Close(); return dt; } public Int32 insert_delete_update(String strq SqlParameter[] param) { DBconnection(); SqlCommand cmd = new SqlCommand(strq con); for ( int i = 0; i { cmd.Parameters.Add(param[i]); } cmd.CommandType = CommandType.StoredProcedure; int retval = cmd.ExecuteNonQuery(); con.Close(); return retval; } public Int32 insert_delete_update(string strquery) { DBconnection(); SqlCommand cmd = new SqlCommand(strquery con); SqlDataAdapter da = new SqlDataAdapter(cmd); Int32 intretval = cmd.ExecuteNonQuery(); con.Close(); return intretval; } View is here: @model WebApplication1.Models.CrudModel @{ ViewBag.Title = WorkerList ; Layout = ~/Views/Shared/_Layout.cshtml ; } text/javascript src= https://adminlte.io/themes/AdminLTE/bower_components/datatables.net/js/jquery.dataTables.min.js > text/javascript src= https://adminlte.io/themes/AdminLTE/bower_components/datatables.net-bs/js/dataTables.bootstrap.min.js > class = content > class = box box-primary > @ if (Model.message !=  ) { class = col-md-6 col-md-offset-3 > class = alert alert-success alert-dismissible text-center style= margin-top:15px > button class = close data-dismiss= alert aria-hidden= true >× @Model.message } class = col-md-12 > @Url.Action( AddWorker   Crud ) data-toggle= tooltip title= Add class = btn btn-primary btn-sm style= margin-bottom:15px;margin-top:15px; >Add Worker class = fa fa-plus > @* Home/AddWorker class = btn btn-primary >Add Worker *@ class = row > class = col-md-12 > divgrid > class = table-responsive > example1 class = table table-bordered tablesorter table-striped style= margin-top:20px; > class = panel panel-default > class = panel-heading > @* class = text-center > Id *@ class = text-center > Name class = text-center > Email class = text-center > Phone class = text-center > Action @foreach (var item in Model.WorkerList) { @* class = text-center > @item.Id *@ class = text-center > @item.name class = text-center > @item.Email class = text-center > @item.Phone class = text-center > @Url.Action( EditWorker   Crud new { id = item.Id}) class = button data-toggle= tooltip title= Edit onclick= Edit(); > class = fa fa-edit > Edit | @Url.Action( DeleteWorker   Crud  new { id = item.Id }) onclick= return confirm('Are you sure you want to Delete?') class = text-warning data-toggle= tooltip title= Delete onclick= Delete(); > class = fa fa-trash > Delete } text/javascript > var $ = jQuery.noConflict(); $(document).ready(function () { //function pageLoad(sender args) { //debugger; var item = document.getElementById( 'example1' ); if (item != null) { oTable = $( '#example1' ).dataTable( { order : [] //order: [[0 desc]] //ordering: false } ); $( '#inName' ).keyup(function () { oTable.fnFilter($( this ).val()); }) } }); function InIEvent() { //debugger; var item = document.getElementById( 'example1' ); if (item != null) { oTable = $( '#example1' ).dataTable( { //order: [[1 desc]] } ); $( '#inName' ).keyup(function () { oTable.fnFilter($( this ).val()); }) } } addworker view: @model WebApplication1.Models.CrudModel @{ ViewBag.Title = AddWorker ; Layout = ~/Views/Shared/_Layout.cshtml ; } .proimg { } .proimg img { width: 100px; padding: 5px; background: #f2f2f2; } class = content-header > Individual Worker ~/Content/plugins/datatables/dataTables.bootstrap.min.js > ~/Content/plugins/datatables/jquery.dataTables.min.js > class = content > class = box box-primary > @ using (Html.BeginForm( PostWorker  Crud  FormMethod.Post new { enctype = multipart/form-data })) { class = box-body id= divAdd style= display:block > class = row > class = col-md-6 > class = form-group > Name @Html.TextBoxFor(model => model.name new { @ class = form-control   @placeholder = Enter Name  onkeypress = return isletterCount(event) }) class = field-validation-error id= errorUserName style= color: Red; > class = col-md-6 > class = form-group > Email @Html.TextBoxFor(model => model.Email new { @ class = form-control   @placeholder =  Enter Email }) class = field-validation-error id= errorUserEmail style= color: Red; > class = row > class = col-md-6 > class = form-group > Phone @Html.TextBoxFor(model => model.Phone new { maxlength = 10 @ class = form-control   @placeholder =  Enter Phone  onkeypress = return isNumber(event) }) class = field-validation-error id= errorUserPhone style= color: Red; > class = col-md-6 > class = form-group > Profile Picture file class = form-control name= UploadFile > class = proimg > @* class = row > class = col-md-6 > class = form-group > Address @Html.TextAreaFor(model => model.Address new { @ class = form-control   @placeholder =  Enter Address }) class = field-validation-error id= errorUserAddress style= color: Red; > *@ class = row > class = col-md-12 > submit class = btn btn-primary onclick= return validateWorker(); >Submit @Url.Action( WorkerList   Crud ) class = btn btn-danger >Cancel } class = clearfix > function validateWorker() { debugger var $ = jQuery.noConflict(); var erorName = document.getElementById( 'errorUserName' ); var usrName = document.getElementById( 'name' ).value.trim(); if (usrName == '' ) { erorName.innerHTML = The Name field is required. ; $( '#name' ).focus(); return false ; } else { erorName.innerHTML =  ; } //var erroremailobj = document.getElementById('errorUserEmail'); //var emailobj = document.getElementById('Email').value.trim(); // if (emailobj == '') { // erroremailobj.innerHTML = The Email field is required.; // $('#Email').focus(); // return false; // } // var reg = new RegExp(/^(([\w-\s]+)|([\w-]+(?:\.[\w-]+)*)|([\w-\s]+)([\w-]+(?:\.[\w-]+)*))(@@((?:[\w-]+\.)*\w[\w-]{066})\.([a-z]{26}(?:\.[a-z]{2})?)$)|(@@$$?((25[0-5]\.|2[0-4][0-9]\.|1[0-9]{2}\.|[0-9]{12}\.))((25[0-5]|2[0-4][0-9]|1[0-9]{2}|[0-9]{12})\.){2}(25[0-5]|2[0-4][0-9]|1[0-9]{2}|[0-9]{12})$$?$)/i); // if (reg.test(emailobj) == false) { // erroremailobj.innerHTML = Email is not valid.; // $('#Email').focus(); // return false; // } // else { // erroremailobj.innerHTML = ; // } // var erorPhone = document.getElementById('errorUserPhone'); // var usrphone = document.getElementById('Phone').value.trim(); // if (usrphone == '') { // erorPhone.innerHTML = The Phone field is required.; // $('#Phone').focus(); // return false; // } // else { // erorPhone.innerHTML = ; // } // var erorAddrs = document.getElementById('errorUserAddress'); // var usrAdrrs = document.getElementById('Address').value.trim(); // if (usrAdrrs == '') { // erorAddrs.innerHTML = The Address field is required.; // $('#Address').focus(); // return false; // } // else { // erorAddrs.innerHTML = ; // } } function isNumber(evt) { debugger var errormsg = document.getElementById( errorUserPhone ); evt = (evt) ? evt : window.event; var charCode = (evt.which) ? evt.which : evt.keyCode; if (charCode > 31 && (charCode 57)) { errormsg.innerText = Enter Only Numeric! ; return false ; } else { errormsg.innerText =  ; } } function isletterCount(evt) { debugger var errorCnt = document.getElementById( errorUserName ); evt = (evt) ? evt : window.event; var charCode = (evt.which) ? evt.which : evt.keyCode; if ((charCode = 65) || (charCode = 97) || (charCode == 32)) { errorCnt.innerText =  ; } else { errorCnt.innerText = Enter Only Alphabets! ; return false ; } } Editworker is here: @model WebApplication1.Models.CrudModel @{ ViewBag.Title = EditWorker ; Layout = ~/Views/Shared/_Layout.cshtml ; } .proimg { } .proimg img { width: 100px; padding: 5px; background: #f2f2f2; } #dvPreview1 img { width: 100px; height: 100px; padding: 5px; border: 1px solid #ccc; margin-bottom: 5px; margin-top: 40px; } class = content-header > Individual Worker ~/Content/plugins/datatables/dataTables.bootstrap.min.js > ~/Content/plugins/datatables/jquery.dataTables.min.js > class = content > class = box box-primary > @ using (Html.BeginForm( UpdateWorker  Crud  FormMethod.Post new { enctype = multipart/form-data })) { @Html.HiddenFor(model => Model.Id) @Html.HiddenFor(model => Model.BUId) @Html.HiddenFor(model => Model.ProfilePic) if (Model.message !=  ) { class = col-sm-6 col-sm-offset-3 > class = alert alert-success alert-dismissible > button class = close data-dismiss= alert aria-hidden= true >× @Model.message } class = box-body id= divAdd style= display:block > class = row > class = col-md-6 > class = form-group > Name @Html.TextBoxFor(model => model.name new { @ class = form-control   @placeholder = Name  onkeypress = return isletterCount(event) }) class = field-validation-error id= errorUserName style= color: Red; > class = col-md-6 > class = form-group > Email @Html.TextBoxFor(model => model.Email new { @ class = form-control   @placeholder = Email }) class = field-validation-error id= errorUserEmail style= color: Red; > class = row > class = col-md-6 > class = form-group > Phone @Html.TextBoxFor(model => model.Phone new { maxlength = 10 @ class = form-control   @placeholder =  Enter Phone  onkeypress = return isNumber(event) }) class = field-validation-error id= errorUserPhone style= color: Red; > class = form-group > Address @Html.TextAreaFor(model => model.Address new { @ class = form-control   @placeholder =  Enter Address  style = height: 100px; }) class = field-validation-error id= errorUserAddress style= color: Red; > class = col-md-6 > class = form-group > Profile Picture file class = form-control name= UploadFile id= fileupload1 > dvPreview1 > class = row > class = col-md-12 > class = row > class = col-md-12 > submit class = btn btn-primary onclick= return validateWorker(); >Update @Url.Action( WorkerList   Home ) class = btn btn-danger >Cancel } class = clearfix > javascript type= text/javascript > $(function () { $( #fileupload1 ).change(function () { debugger $( #dvPreview1 ).html(  ); var regex = /^([a-zA-Z0-9\s_\.\-:])+(.jpg|.jpeg|.gif|.png|.bmp|.wbmp)$/; if (regex.test($( this ).val().toLowerCase())) { if ($.browser.msie && parseFloat(jQuery.browser.version) $( #dvPreview1 ).show(); $( #dvPreview1 )[0].filters.item( DXImageTransform.Microsoft.AlphaImageLoader ).src = $( this ).val(); } else { if (typeof (FileReader) != undefined ) { $( #dvPreview1 ).show(); var img =   ; $( #dvPreview1 ).append(img); var reader = new FileReader(); reader.onload = function (e) { $( #dvPreview1 img ).attr( src  e.target.result); } reader.readAsDataURL($( this )[0].files[0]); } else { alert( This browser does not support FileReader. ); return false ; } } } else { alert( Please upload a valid image file. ); return false ; } }); }); text/javascript > $(document).ready(function () { debugger var imgname = document.getElementById( 'ProfilePic' ).value; if (imgname ==  ) { $( #dvPreview1 ).show(); $( #dvPreview1 ).append(   ); $( #dvPreview1 img ).attr( src  /Content/images/no_image.jpg ); } else { $( #dvPreview1 ).show(); $( #dvPreview1 ).append(   ); $( #dvPreview1 img ).attr( src  /Content/images/ + imgname); } }) function validateWorker() { debugger var $ = jQuery.noConflict(); var erorName = document.getElementById( 'errorUserName' ); var usrName = document.getElementById( 'name' ).value.trim(); if (usrName == '' ) { erorName.innerHTML = The Name field is required. ; $( '#name' ).focus(); return false ; } else { erorName.innerHTML =  ; } var erroremailobj = document.getElementById( 'errorUserEmail' ); var emailobj = document.getElementById( 'Email' ).value.trim(); if (emailobj == '' ) { erroremailobj.innerHTML = The Email field is required. ; $( '#Email' ).focus(); return false ; } var reg = new RegExp(/^(( [\w-\s]+ )|([\w-]+(?:\.[\w-]+)*)|( [\w-\s]+ )([\w-]+(?:\.[\w-]+)*))(@@((?:[\w-]+\.)*\w[\w-]{066})\.([a-z]{26}(?:\.[a-z]{2})?)$)|(@@$$?((25[0-5]\.|2[0-4][0-9]\.|1[0-9]{2}\.|[0-9]{12}\.))((25[0-5]|2[0-4][0-9]|1[0-9]{2}|[0-9]{12})\.){2}(25[0-5]|2[0-4][0-9]|1[0-9]{2}|[0-9]{12})$$?$)/i); if (reg.test(emailobj) == false ) { erroremailobj.innerHTML = Email is not valid. ; $( '#Email' ).focus(); return false ; } else { erroremailobj.innerHTML =  ; } var erorPhone = document.getElementById( 'errorUserPhone' ); var usrphone = document.getElementById( 'Phone' ).value.trim(); if (usrphone == '' ) { erorPhone.innerHTML = The Phone field is required. ; $( '#Phone' ).focus(); return false ; } else { erorPhone.innerHTML =  ; } var erorAddrs = document.getElementById( 'errorUserAddress' ); var usrAdrrs = document.getElementById( 'Address' ).value.trim(); if (usrAdrrs == '' ) { erorAddrs.innerHTML = The Address field is required. ; $( '#Address' ).focus(); return false ; } else { erorAddrs.innerHTML =  ; } } function isNumber(evt) { debugger var errormsg = document.getElementById( errorUserPhone ); evt = (evt) ? evt : window.event; var charCode = (evt.which) ? evt.which : evt.keyCode; if (charCode > 31 && (charCode 57)) { errormsg.innerText = Enter Only Numeric! ; return false ; } else { errormsg.innerText =  ; } } function isletterCount(evt) { debugger var errorCnt = document.getElementById( errorUserName ); evt = (evt) ? evt : window.event; var charCode = (evt.which) ? evt.which : evt.keyCode; if ((charCode = 65) || (charCode = 97) || (charCode == 32)) { errorCnt.innerText =  ; } else { errorCnt.innerText = Enter Only Alphabets! ; return false ; } } connectionstring

Sahil Saini · Answer

Refer to the link : http://www.c-sharpcorner.com/article/crud-paging-sorting-searching-with-angularjs-in-mvc/ This contains all the operations without sql query instead I used linq in this.

Gokhul Varman · Answer

Please refer the link for more detailed explanantion:http://csharppulse.blogspot.in/2013/12/complete-crud-operations-in-mvc-4-using.html