public List <Ticketinfo> SelectAllTicketinfo()
{
List <Ticketinfo> tlst = new List <Ticketinfo>();
Ticketinfo tf;
using (OTMDataContext db = new OTMDataContext())
{
var data = (from a in db.Tickets select a).ToList();
foreach (var obj in data)
{
tf = new Ticketinfo();
tf.TicketID = obj.TicketID;
tf.Description = obj.Description;
tf.CreatedDate = obj.CreatedDate;
tf.UpdatedDate = obj.UpdatedDate;
tf.TeamID = obj.TeamID;
tf.Status = obj.Status;
tf.Ticket_Severity = obj.Ticket_Severity;
tf.Expireddate = (DateTime)obj.ExpiredDate;
tf.Ticket_Estimated_Time = (int)obj.Ticket_Estimated_Time;
tlst.Add(tf);
}
}
return(tlst);
}
public bool updateTicketinfobyId(string ID, Ticketinfo info)
{
using (OTMDataContext db = new OTMDataContext())
{
var source = (from a in db.Tickets where a.TicketID == ID select a).FirstOrDefault();
source.Status = info.Status;
db.SubmitChanges();
return(true);
}
}
public static void WriteJson(this Ticketinfo value, JsonWriter writer, JsonSerializer serializer)
{
switch (value)
{
case Ticketinfo.DiY手做教學200元人提供用餐服務150人: serializer.Serialize(writer, "DIY手做教學 200元/人提供用餐服務 150/人"); break;
case Ticketinfo.Empty: serializer.Serialize(writer, ""); break;
case Ticketinfo.免費參觀: serializer.Serialize(writer, "免費參觀"); break;
case Ticketinfo.新台幣50元: serializer.Serialize(writer, "新台幣50元"); break;
}
}
public void insertto(Ticketinfo tinfo)
{
using (OTMDataContext db = new OTMDataContext())
{
Ticket ti = new Ticket();
Guid id = Guid.NewGuid();
ti.TicketID = id.ToString();
ti.TeamID = id.ToString();
ti.Description = tinfo.Description;
ti.Status = tinfo.Status;
ti.CreatedDate = DateTime.UtcNow.AddMinutes(390);
ti.UpdatedDate = DateTime.UtcNow.AddMinutes(390);
ti.ExpiredDate = DateTime.UtcNow.AddMinutes(390);
db.Tickets.InsertOnSubmit(ti);
db.SubmitChanges();
}
}
public IEnumerable <Record> Get(string k = "", string z = "", Ticketinfo t = Ticketinfo.Empty)
{
var data = this.db.ScenicSpots.AsQueryable();
if (!String.IsNullOrEmpty(k))
{
data = data.Where(x => x.Name.Contains(k) || x.Description.Contains(k));
}
if (!String.IsNullOrEmpty(z))
{
data = data.Where(x => x.Zone == z);
}
if (t != Ticketinfo.Empty)
{
data = data.Where(x => x.Ticketinfo == t);
}
return(data.Take(10));
}
public void addTicket(TicketForm ticket, string memno, int trainno, string buytime)
{
List <Ticket> data = ticketDAO.getTicket(memno, trainno, buytime);
Ticketinfo[] ticketinfo = new Ticketinfo[data.Count];
for (int i = 0; i < data.Count; i++)
{
ticketinfo[i] = new Ticketinfo();
ticketinfo[i].setticketno = data[i].ticketno;
ticketinfo[i].settrainno = data[i].trainno;
ticketinfo[i].setstarttime = data[i].starttime;
ticketinfo[i].setstoptime = data[i].stoptime;
ticketinfo[i].setmembername = data[i].membername;
ticketinfo[i].setmemberno = data[i].memberno;
ticketinfo[i].setdeparture = data[i].departure;
ticketinfo[i].setdestination = data[i].destination;
ticket.flowLayoutPanel1.Controls.Add(ticketinfo[i]);
}
}
public void TicketInsert(Ticketinfo tinfo)
{
Tdao.insertto(tinfo);
}
