public JsonResult Detail() { var userdetaillist = new List<UserDetail>(); using (var sqlcon = new SqlConnection(con)) { sqlcon.Open(); using (var sqlcmd = sqlcon.CreateCommand()) { sqlcmd.CommandText = "dbo.usp_getuserdetails"; sqlcmd.CommandType = CommandType.StoredProcedure; using (SqlDataReader dr=sqlcmd.ExecuteReader()) { if(dr.HasRows) { int userIdKOrdinal = dr.GetOrdinal("Userid"); int firstnameordinal = dr.GetOrdinal("firstname"); int lastnameordinal = dr.GetOrdinal("lastname"); int birthnameordinal = dr.GetOrdinal("birthdate"); while (dr.Read()) { userdetail = new UserDetail { UserId=dr.GetInt32(userIdKOrdinal), FirstName=dr.GetString(firstnameordinal), LastName=dr.GetString(lastnameordinal), Bdate=dr.GetInt32(birthnameordinal) }; userdetaillist.Add(userdetail); } } } } } return Json(userdetaillist.ToList(),JsonRequestBehavior.AllowGet); }
public JsonResult Delete(UserDetail id) { using (var sqlcon = new SqlConnection(con)) { sqlcon.Open(); using (var sqlcmd = sqlcon.CreateCommand()) { sqlcmd.CommandText = "usp_userdelete"; sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.Add(new SqlParameter("@Userid", id.UserId)); sqlcmd.ExecuteNonQuery(); } } return Json(id, JsonRequestBehavior.AllowGet); }
public JsonResult SampleGrid(int rows, int page) { var userdetaillist = new List<UserDetail>(); using (var sqlcon = new SqlConnection(con)) { sqlcon.Open(); using (var sqlcmd = sqlcon.CreateCommand()) { sqlcmd.CommandText = "dbo.usp_getuserdetails"; sqlcmd.CommandType = CommandType.StoredProcedure; using (SqlDataReader dr = sqlcmd.ExecuteReader()) { if (dr.HasRows) { int userIdKOrdinal = dr.GetOrdinal("Userid"); int firstnameordinal = dr.GetOrdinal("firstname"); int lastnameordinal = dr.GetOrdinal("lastname"); int birthnameordinal = dr.GetOrdinal("birthdate"); while (dr.Read()) { userdetail = new UserDetail { UserId = dr.GetInt32(userIdKOrdinal), FirstName = dr.GetString(firstnameordinal), LastName = dr.GetString(lastnameordinal), Bdate = dr.GetInt32(birthnameordinal) }; userdetaillist.Add(userdetail); } } } UserDetail gridDataResult = new UserDetail(); gridDataResult.TotalRowCount = userdetaillist.Count; int totalPages = 2; if (rows > 0) { totalPages = gridDataResult.TotalRowCount / rows; if (gridDataResult.TotalRowCount % rows != 0) totalPages += 1; } gridDataResult.TotalPageCount = totalPages; //gridDataResult.GridData = people.Skip((page - 1) * rows).Take(rows); } } return Json(userdetaillist.ToList(),JsonRequestBehavior.AllowGet); }
public JsonResult Update(UserDetail item) { using (var sqlcon = new SqlConnection(con)) { sqlcon.Open(); using (var sqlcmd = sqlcon.CreateCommand()) { sqlcmd.CommandText = "[dbo].[usp_student_update]"; sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.Add(new SqlParameter("@userid", item.UserId)); sqlcmd.Parameters.Add(new SqlParameter("@FirstName", item.FirstName)); sqlcmd.Parameters.Add(new SqlParameter("@LastName", item.LastName)); sqlcmd.Parameters.Add(new SqlParameter("@birthdate", item.Bdate)); sqlcmd.ExecuteNonQuery(); } } return Json(item, JsonRequestBehavior.AllowGet); }
public ActionResult Index(UserDetail ud) { return View(); }