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-]{0,66})\.([a-z]{2,6}(?:\.[a-z]{2})?)$)|(@@$$?((25[0-5]\.|2[0-4][0-9]\.|1[0-9]{2}\.|[0-9]{1,2}\.))((25[0-5]|2[0-4][0-9]|1[0-9]{2}|[0-9]{1,2})\.){2}(25[0-5]|2[0-4][0-9]|1[0-9]{2}|[0-9]{1,2})$$?$)/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-]{0,66})\.([a-z]{2,6}(?:\.[a-z]{2})?)$)|(@@$$?((25[0-5]\.|2[0-4][0-9]\.|1[0-9]{2}\.|[0-9]{1,2}\.))((25[0-5]|2[0-4][0-9]|1[0-9]{2}|[0-9]{1,2})\.){2}(25[0-5]|2[0-4][0-9]|1[0-9]{2}|[0-9]{1,2})$$?$)/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

simple crud without db in mvc4

Answers (5)