simple crud without db in mvc4

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 < param.Length; 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 < param.Length; 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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manoj Maharana9y ago
In page use this script:

in layout:
Manoj Maharana9y ago
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 Maharana9y ago
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 < param.Length; 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 < param.Length; 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