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));
}
}
