public IHttpActionResult UpdateTicket([FromBody] TicketCenterAPI.Models.Ticket ticket)
{
using (var context = new TicketCenterAPI.Models.ticketcenterdbEntities1())
{
context.Configuration.ProxyCreationEnabled = false;
//is the model with binding is incorrect
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
//todo change name of SP admin used too
// context.usp_ticket(ticket.TicketId,ticket.TechId,ticket.StatusId, ticket.Comment);
context.usp_ticket(ticket.TicketId, ticket.TechId, ticket.StatusId, ticket.Comment);
}
catch
{
return(NotFound());
}
return(Ok("Update succesfull"));
}
}
public IHttpActionResult UpdateCategory([FromBody] TicketCenterAPI.Models.Category category)
{
using (var context = new TicketCenterAPI.Models.ticketcenterdbEntities1())
{
context.Configuration.ProxyCreationEnabled = false;
//is the model with binding is incorrect
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
//todo change name of SP admin used too
context.usp_category(category.CategoryId, category.CategoryDesc);
}
catch
{
return(NotFound());
}
return(Ok("Update succesfull"));
}
}
public IHttpActionResult GetAllCategories()
{
//using method calls dispose to dispose any resourses after the call
//context access the data model from the database
using (var context = new TicketCenterAPI.Models.ticketcenterdbEntities1())
{
context.Configuration.ProxyCreationEnabled = false;
// alternative to using store procedure
var categories = context.sp_select_all_categories();
if (categories == null)
{
return(NotFound());
}
//write the query to search the database linq
// var query = (from c in context.Categories select c).ToList();
//if we have a results get categories to json
string jsonArrayString = Newtonsoft.Json.JsonConvert.SerializeObject(categories);
JArray jsonArray = JArray.Parse(jsonArrayString);
return(Ok(jsonArray));
}
}
public IHttpActionResult GetRoles()
{
using (var context = new TicketCenterAPI.Models.ticketcenterdbEntities1())
{
context.Configuration.ProxyCreationEnabled = false;
context.Configuration.LazyLoadingEnabled = false;
var roles = context.sp_select_all_roles();
if (roles == null)
{
return(NotFound());
}
//if we have a results get roles to json string
string jsonArrayString = Newtonsoft.Json.JsonConvert.SerializeObject(roles);
//parse string json array to json objects
JArray jsonArray = JArray.Parse(jsonArrayString);
/*
* get specific object
* dynamic data = JObject.Parse(jsonArray[0].ToString());
*/
return(Ok(jsonArray));
}
}
public HttpResponseMessage GetUserTicketById(int id)
{
using (var context = new TicketCenterAPI.Models.ticketcenterdbEntities1())
{
context.Configuration.ProxyCreationEnabled = false;
var userTicket = context;
string result = "";
if (userTicket != null)
{
//convert list to json
result = Newtonsoft.Json.JsonConvert.SerializeObject(userTicket);
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Something went wrong"));
}
var response = new HttpResponseMessage
{
Content = new StringContent(result),
StatusCode = HttpStatusCode.OK
};
response.Content.Headers.Clear();
response.Content.Headers.Add("Content-Type", "application/json");
return(response);
}
}
public IHttpActionResult AddStatus([FromBody] TicketCenterAPI.Models.Status status)
{
using (var context = new TicketCenterAPI.Models.ticketcenterdbEntities1())
{
context.Configuration.ProxyCreationEnabled = false;
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
//by default ticket are open
context.ins_status(status.StatusDesc);
}
catch
{
return(InternalServerError());
}
//TODO delete response
return(Ok("Succesfull created"));
}
}
public IHttpActionResult DeleteStatus(int id)
{
using (var context = new TicketCenterAPI.Models.ticketcenterdbEntities1())
{
context.Configuration.ProxyCreationEnabled = false;
try
{
context.sp_delete_status_by_id(id);
}
catch
{
return(InternalServerError());
}
return(Ok("Delete succesfull"));
}
}
public IHttpActionResult GetTicketByClientId(int id)
{
using (var context = new TicketCenterAPI.Models.ticketcenterdbEntities1())
{
context.Configuration.ProxyCreationEnabled = false;
var ticket = context.sp_get_chat_ticket_by_client_id(id);
if (ticket == null)
{
return(NotFound());
}
//convert list to json
string jsonArrayString = Newtonsoft.Json.JsonConvert.SerializeObject(ticket);
JArray jsonArray = JArray.Parse(jsonArrayString);
return(Ok(jsonArray));
}
}
public IHttpActionResult GetStatusSumary()
{
using (var context = new TicketCenterAPI.Models.ticketcenterdbEntities1())
{
context.Configuration.ProxyCreationEnabled = false;
var category = context.sp_summary_status();
if (category == null)
{
return(NotFound());
}
//convert list to json
string jsonArrayString = Newtonsoft.Json.JsonConvert.SerializeObject(category);
JArray jsonArray = JArray.Parse(jsonArrayString);
return(Ok(jsonArray));
}
}
public IHttpActionResult GetTicketByIdPagi(int pageIndex, int pageSize, int userId)
{
using (var context = new TicketCenterAPI.Models.ticketcenterdbEntities1())
{
context.Configuration.ProxyCreationEnabled = false;
var ticket = context.sp_get_user_ticket_by_id_pagi(pageIndex, pageSize, userId);
if (ticket == null)
{
return(NotFound());
}
string jsonArrayString = Newtonsoft.Json.JsonConvert.SerializeObject(ticket);
JArray jsonArray = JArray.Parse(jsonArrayString);
return(Ok(jsonArray));
}
}
public HttpResponseMessage GetloginUser([FromBody] TicketCenterAPI.Models.User user)
{
using (var context = new TicketCenterAPI.Models.ticketcenterdbEntities1())
{
context.Configuration.ProxyCreationEnabled = false;
var count = (from u in context.Users select u).Where(u => u.Email == user.Email && u.Password == user.Password)
.ToList().Count;
//get all tickets
var userlogin = context.sp_get_login(user.Email, user.Password);
string result = "";
if (userlogin != null && count > 0)
{
Debug.WriteLine(userlogin);
//convert list to json
result = Newtonsoft.Json.JsonConvert.SerializeObject(userlogin);
}
else
{
//user not found
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Invalid Credentials"));
}
var response = new HttpResponseMessage
{
Content = new StringContent(result),
StatusCode = HttpStatusCode.OK
};
response.Content.Headers.Clear();
response.Content.Headers.Add("Content-Type", "application/json");
return(response);
}
}
public IHttpActionResult GetAllTickets(int pageIndex, int pageSize)
{
using (var context = new TicketCenterAPI.Models.ticketcenterdbEntities1())
{
context.Configuration.ProxyCreationEnabled = false;
//get all tickets
var tickets = context.sp_select_all_tickets(pageIndex, pageSize);
if (tickets == null)
{
return(NotFound());
}
//convert list to json
string jsonArrayString = Newtonsoft.Json.JsonConvert.SerializeObject(tickets);
JArray jsonArray = JArray.Parse(jsonArrayString);
return(Ok(jsonArray));
}
}
public IHttpActionResult AddCategory([FromBody] TicketCenterAPI.Models.Category category)
{
using (var context = new TicketCenterAPI.Models.ticketcenterdbEntities1())
{
context.Configuration.ProxyCreationEnabled = false;
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
context.ins_category(category.CategoryDesc);
}
catch
{
return(InternalServerError());
}
return(Ok("Saved succesfull"));
}
}
public IHttpActionResult AddTicket([FromBody] TicketCenterAPI.Models.Ticket ticket)
{
using (var context = new TicketCenterAPI.Models.ticketcenterdbEntities1())
{
if (!ModelState.IsValid)
{
return(NotFound());
}
context.Configuration.ProxyCreationEnabled = false;
try
{
//by default ticket are open
context.ins_tickets(ticket.Description, "", ticket.CategoryId, 1, ticket.ClientId);
}
catch
{
return(InternalServerError());
}
return(Ok("Ticket succesfull created"));
}
}
