public int Update(string FromStation, string ToStation, DateTime Date, string Id)
{
string FromCode = StationCode(FromStation);
string ToCode = StationCode(ToStation);
string IdCode = string.Empty;
if (Id == "成人")
{
IdCode = "ADULT";
}
if (Id == "学生")
{
IdCode = "0X00";
}
SpiderTicket spider = new SpiderTicket(Date.ToString("yyyy-MM-dd"), FromCode, ToCode, IdCode);
spider.Get();
Model.Ticket[] AllTicket = new Model.Ticket[spider.Count()];
AllTicket = spider.GetAll();
for (int i = 0; i < AllTicket.Length; i++)
{
AllTicket[i].Identity = Id;
}
return(dal.Add(FromStation, ToStation, AllTicket));
}
public IActionResult Upsert(int ticketNumber, string description, string comment, int status, int category)
{
try
{
Model.Ticket ticket = new Model.Ticket()
{
TicketNumber = ticketNumber,
Description = description,
Comment = comment == null? string.Empty : comment,
Status = new Model.Status()
{
Code = status
},
Category = new Model.Category()
{
Code = category
}
};
int ticketID = 0;
using (var client = new HttpClient())
{
client.BaseAddress = new Uri("http://ticketscoreapplication20180922064643.azurewebsites.net");
ticketID = client.PostAsJsonAsync <Model.Ticket>("/api/tickets", ticket).Result.Content.ReadAsAsync <int>().Result;
}
return(Ok(ticketID));
}
catch (Exception ex)
{
return(StatusCode(500));
}
}
public int Add(string SearchForm, string SearchTo, Model.Ticket model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [Ticket](");
strSql.Append("[TrainId],[FromStation],[ToStation],[SearchFrom],[SearchTo],[TicketDate],[StartTime],[ArriveTime],[LastedTime],[TzNum]," +
"[YdNum],[EdNum],[GrwNum],[RwNum],[DwNum],[YwNum],[RzNum],[YzNum],[WzNum],[QtNum],[Identity],[QueryTime] )");
strSql.Append(" values (");
strSql.Append("@TrainId,@FromStation,@ToStation,@SearchFrom,@SearchTo,@TicketDate,@StartTime,@ArriveTime,@LastedTime,@TzNum," +
"@YdNum,@EdNum,@GrwNum,@RwNum,@DwNum,@YwNum,@RzNum,@YzNum,@WzNum,@QtNum,@Identity,@QueryTime)");
OleDbParameter[] parameters =
{
new OleDbParameter("@TrainId", OleDbType.VarChar, 255),
new OleDbParameter("@FromStation", OleDbType.VarChar, 255),
new OleDbParameter("@ToStation", OleDbType.VarChar, 255),
new OleDbParameter("@SearchFrom", OleDbType.VarChar, 255),
new OleDbParameter("@SearchTo", OleDbType.VarChar, 255),
new OleDbParameter("@TicketDate", OleDbType.VarChar, 255),
new OleDbParameter("@StartTime", OleDbType.VarChar, 255),
new OleDbParameter("@ArriveTime", OleDbType.VarChar, 255),
new OleDbParameter("@LastedTime", OleDbType.VarChar, 255),
new OleDbParameter("@TzNumNum", OleDbType.VarChar, 255),
new OleDbParameter("@YdNum", OleDbType.VarChar, 255),
new OleDbParameter("@EdNum", OleDbType.VarChar, 255),
new OleDbParameter("@GrwNum", OleDbType.VarChar, 255),
new OleDbParameter("@RwNum", OleDbType.VarChar, 255),
new OleDbParameter("@DwNum", OleDbType.VarChar, 255),
new OleDbParameter("@YwNum", OleDbType.VarChar, 255),
new OleDbParameter("@RzNum", OleDbType.VarChar, 255),
new OleDbParameter("@YzNum", OleDbType.VarChar, 255),
new OleDbParameter("@WzNum", OleDbType.VarChar, 255),
new OleDbParameter("@QtNum", OleDbType.VarChar, 255),
new OleDbParameter("@Identity", OleDbType.VarChar, 255),
new OleDbParameter("@QueryTime", OleDbType.VarChar, 255)
};
parameters[0].Value = model.TrainId;
parameters[1].Value = model.FromStation;
parameters[2].Value = model.ToStation;
parameters[3].Value = SearchForm;
parameters[4].Value = SearchTo;
parameters[5].Value = model.TicketDate;
parameters[6].Value = model.StartTime;
parameters[7].Value = model.ArriveTime;
parameters[8].Value = model.LastedTime;
parameters[9].Value = model.TzNum;
parameters[10].Value = model.YdNum;
parameters[11].Value = model.EdNum;
parameters[12].Value = model.GrwNum;
parameters[13].Value = model.RwNum;
parameters[14].Value = model.DwNum;
parameters[15].Value = model.YwNum;
parameters[16].Value = model.RzNum;
parameters[17].Value = model.YzNum;
parameters[18].Value = model.WzNum;
parameters[19].Value = model.QtNum;
parameters[20].Value = model.Identity;
parameters[21].Value = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
return(SqlHelper.ExecuteNonQuery(strSql.ToString(), parameters));
}
public static Model.Ticket FromCore(this Entities.Ticket ticket)
{
Model.Ticket result = null;
if (ticket != null)
{
result = new Model.Ticket()
{
DateOfAccident = ticket.DateOfAccident,
Description = ticket.Description,
Priority = (int)ticket.Priority,
Id = ticket.Id
};
if (ticket.Images != null)
{
var images = new List <Model.Image>();
foreach (var image in ticket.Images)
{
images.Add(image.FromCore());
}
result.Images = images;
}
}
return(result);
}
public static Entities.Ticket ToCore(this Model.Ticket ticket)
{
Entities.Ticket result = null;
if (ticket != null)
{
result = new Entities.Ticket()
{
DateOfAccident = ticket.DateOfAccident,
Description = ticket.Description,
Priority = (Entities.PriorityEnum)ticket.Priority,
Id = ticket.Id
};
if (ticket.Images != null)
{
foreach (var image in ticket.Images)
{
result.Images.Add(image.ToCore());
}
}
}
return(result);
}
public int Add(string SearchForm, string SearchTo, Model.Ticket[] Allmodel)
{
int n = 0;
for (int i = 0; i < Allmodel.Length; i++)
{
Model.Ticket model = new Model.Ticket();
model = Allmodel[i];
n += Add(SearchForm, SearchTo, model);
}
return(n);
}
public IActionResult upsert([FromBody] Model.Ticket ticket)
{
try
{
int ticketNumber = ticketsService.upsert(ticket);
return(Ok(ticketNumber));
}
catch
{
return(StatusCode(500));
}
}
public ActionResult Create(TicketCreateModel m)
{
CRM.Model.Ticket ticket = new Model.Ticket();
ticket.Title = m.Title;
//ticket.BranchId = 3;
ticket.Description = m.Description;
//ticket.Priority = m.SeverityCode;
//ticket.TicketType = m.TicketType;
//ticket.ModuleId = m.ModuleId;
ticket.ProductId = m.ProductId;
ticket.VersionId = m.VersionId;
TicketManager<Ticket> ticketManager = new TicketManager<Ticket>(new TicketStore<Ticket>());
ticketManager.CreateTicket(ticket);
return RedirectToAction("List");
}
public IActionResult find(int ticketNumber)
{
try
{
Model.Ticket ticket = ticketsService.find(ticketNumber);
if (ticket == null)
{
return(NotFound());
}
return(Ok(ticket));
}
catch (Exception e)
{
return(StatusCode(500));
}
}
public Ticket find(int ticketNumber)
{
try
{
Model.Ticket ticket = ticketsRepository.find(ticketNumber);
if (JsonConvert.SerializeObject(ticket) == JsonConvert.SerializeObject(new Model.Ticket()))
{
return(null);
}
return(ticket);
}
catch (Exception ex)
{
throw ex;
}
}
public void upsertTicket()
{
Model.Ticket ticket = new Model.Ticket()
{
Description = "Test",
Comment = "Comment",
Category = new Model.Category()
{
Code = 1
},
Status = new Model.Status()
{
Code = 1
}
};
int newTicketNumber = iTicketService.upsert(ticket);
Assert.NotEqual(0, newTicketNumber);
}
private void btnSubmitTicket_Click(object sender, EventArgs e)
{
if (CheckFields())
{
DateTime deadline = DateTime.Now;
if (dropDownDeadline.Text == "7 days")
{
deadline = DateTime.Today.AddDays(7);
}
else if (dropDownDeadline.Text == "14 days")
{
deadline = DateTime.Today.AddDays(14);
}
else if (dropDownDeadline.Text == "28 days")
{
deadline = DateTime.Today.AddDays(28);
}
else if (dropDownDeadline.Text == "6 months")
{
deadline = DateTime.Today.AddDays(182);
}
Model.Ticket newTicket = new Model.Ticket
{
Date = dateTimeIncident.Value.Date,
Subject = txtSubject.Text,
User = dropDownUsers.Text,
Priority = dropDownPriority.Text,
Deadline = deadline,
Description = txtDescription.Text,
Type = dropDownIncidents.Text
};
ticketService.AddTicket(newTicket);
MessageBox.Show("Ticket sent!");
this.Close();
}
}
public void notFoundByTicketNumber()
{
Model.Ticket result = iTicketService.find(100);
Assert.Null(result);
}
public void findByTicketNumber()
{
Model.Ticket result = iTicketService.find(1);
Assert.NotNull(result);
}
public int Add(string SearchFrom, string SearchTo, Model.Ticket model)
{
return(dal.Add(SearchFrom, SearchTo, model));
}
