public IList <SupportRequests> GetSupportRequestDetails()
{
IList <SupportRequests> requestList = new List <SupportRequests>();
sqlhelper_obj = new SqlHelper();
try
{
using (SqlConnection sqlconn_obj = new SqlConnection())
{
sqlconn_obj.ConnectionString = sqlhelper_obj.GetConnectionSrting();
using (SqlCommand sqlcmd_getzones_obj = new SqlCommand("PARK_PROC_GetSupportRequestsList", sqlconn_obj))
{
sqlcmd_getzones_obj.CommandType = CommandType.StoredProcedure;
sqlcmd_getzones_obj.CommandTimeout = 0;
DataSet ds;
using (SqlDataAdapter da = new SqlDataAdapter(sqlcmd_getzones_obj))
{
ds = new DataSet();
da.Fill(ds);
}
DataTable dt = ds.Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
SupportRequests request_obj = new SupportRequests();
request_obj.SupportRequestID = Convert.ToInt32(dt.Rows[i]["SupportRequestID"]);
request_obj.Name = Convert.ToString(dt.Rows[i]["Name"]);
request_obj.PhoneNumber = Convert.ToString(dt.Rows[i]["PhoneNumber"]);
request_obj.Email = Convert.ToString(dt.Rows[i]["Email"]);
request_obj.Message = Convert.ToString(dt.Rows[i]["Message"]);
request_obj.IsActive = Convert.ToBoolean(dt.Rows[i]["IsActive"]);
request_obj.CreatedOn = dt.Rows[i]["CreatedOn"] == DBNull.Value ? Convert.ToDateTime(null) : Convert.ToDateTime(dt.Rows[i]["CreatedOn"]);
requestList.Add(request_obj);
}
}
}
return(requestList);
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult CreateRequest(SupportRequests support)
{
var PlayerId = User.Identity.GetUserId();
var PlayerUser = db.Users.Include("Gladiators").Include("Supports").SingleOrDefault(u => u.Id == PlayerId);
if (ModelState.IsValid)
{
support.User = PlayerUser.UserName;
support.Email = PlayerUser.Email;
support.Date = DateTime.Now;
support.Solved = "No";
PlayerUser.Supports.Add(support);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(support));
}
