public ActionResult AdminNap() { string queryString = @"SELECT NapName, NapDate, StartTime, EndTime from Nap"; List <Naps> naps = new List <Naps>(); using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand(queryString, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { var nap = new Naps(); nap.NapName = reader["NapName"].ToString(); nap.NapDate = Convert.ToDateTime(reader["NapDate"]); nap.StartTime = Convert.ToDateTime(reader["StartTime"]); nap.StartTime = Convert.ToDateTime(reader["StartTime"]); naps.Add(nap); } } return(View("AdminNap")); }
public async Task <ActionResult> PostReprocess(decimal[] selected_record, string batchid) { try { var rst = Naps.PostNapsReprocess(selected_record, User.Identity.Name); if (rst > 0) { var rec = await _repo.GetNapsApprovedAsync(batchid); var html = PartialView("_ViewNaps", rec).RenderToString(); return(Json(new { RespCode = 0, RespMessage = "Reprocess Initiation Completed Successfully", data_html = html }, JsonRequestBehavior.AllowGet)); } return(Json(new { RespCode = 1, RespMessage = "Unable to Process Request. Try again or contact Administrator." }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { RespCode = 1, RespMessage = "Problem Processing Request." }, JsonRequestBehavior.AllowGet)); } }