public IHttpActionResult PostTicket(UserTicket uTic)
{
//if (!ModelState.IsValid)
//{
// return BadRequest(ModelState);
//}
if (uTic == null)
{
return(BadRequest(ModelState));
}
//JavaScriptSerializer j = new JavaScriptSerializer();
//UserTicket uTic = (UserTicket)j.Deserialize(uTicStr, typeof(UserTicket));
Ticket ticket = new Ticket();
//uTic.TicketId = uTic.TicketId;
ticket.Subject = uTic.Subject;
ticket.ConstituentID = uTic.ConstituentID;
ticket.Service = uTic.Service;
ticket.IssueId = (int)uTic.IssueId;
ticket.IssueDetailId = (int)uTic.IssueDetailId;
ticket.IssueAddInfoId = (int)uTic.IssueAddInfoId;
ticket.Description = uTic.Description;
ticket.TicketStatus = uTic.TicketStatus;
ticket.DateReported = DateTime.Now.Date;
ticket.TimeReported = DateTime.Now.TimeOfDay;
db.Tickets.Add(ticket);
db.SaveChanges();
// Only save location if RFS ticket
if (uTic.TicketType == 1)
{
TicketLocation ticLoc = new TicketLocation();
ticLoc.Latitude = Convert.ToDouble(ticketLoc.Latitude);
ticLoc.Longitude = Convert.ToDouble(ticketLoc.Longitude);
ticLoc.Location = Convert.ToString(ticketLoc.Address);
ticLoc.ParcelNo = Convert.ToString(ticketLoc.ParcelNo);
ticLoc.CrossSt1 = Convert.ToString(ticketLoc.CrossSt1);
ticLoc.CrossSt2 = Convert.ToString(ticketLoc.CrossSt2);
if (ticLoc.Location.Contains("Henderson"))
{
ticLoc.City = "Henderson";
}
else
{
ticLoc.City = "Las Vegas";
}
ticLoc.State = "NV";
// Now use the identity of created ticket
ticLoc.TicketId = ticket.TicketId;
db.TicketLocations.Add(ticLoc);
db.SaveChanges();
}
// Also store attachments
if (FileUploadController.postedFiles.Count > 0)
{
var fileNameUnique = "";
foreach (var fileName in FileUploadController.postedFiles)
{
var fileSourcePath = Path.Combine(HttpContext.Current.Server.MapPath("~/TempFiles"), fileName);
// Get the complete file path
fileNameUnique = ticket.TicketId + fileName;
var fileDestPath = Path.Combine(HttpContext.Current.Server.MapPath("~/UploadedFiles"), fileNameUnique);
// Save the uploaded file to "UploadedFiles" folder
File.Move(fileSourcePath, fileDestPath);
// Also store file path in DB
TicAttachment ticAttachment = new TicAttachment
{
//uTic.TicketId = uTic.TicketId;
TicketId = ticket.TicketId,
FilePath = fileDestPath,
FileName = fileNameUnique
};
db.TicAttachments.Add(ticAttachment);
db.SaveChanges();
}
//var fileName = FileUploadController.postedFiles.First();
FileUploadController.postedFiles.Clear();
}
//return CreatedAtRoute("DefaultApi", new { id = ticket.TicketId }, ticket);
return(Ok("OK"));
}