//Upload User CreditsS
public bool UploadCredit(EventTicket _ticket)
{
using (EventrixDBDataContext db = new EventrixDBDataContext())
{
try
{
Ticket_Template toInsert = (from st in db.Ticket_Templates where st.TicketID.Equals(_ticket._TicketID) select st).First();
toInsert.Credit = _ticket._Credit;
db.SubmitChanges();
List <Guest_Ticket> insert = (from st in db.Guest_Tickets where st.ticket_temp_id.Equals(_ticket._TicketID) && st.G_ID.Equals(_ticket._GuestID) select st).ToList();
// toInsert.Credit = _ticket._Credit;
foreach (Guest_Ticket gt in insert)
{
var query = (from qr in db.Guest_QRCodes where qr.ticket_Id.Equals(gt.ticket_Id) select qr).First();
Guest_QRCode GQR = query;
GQR.Credit = _ticket._Credit;
db.SubmitChanges();
}
return(true);
}
catch
{
return(false);
}
}
}
public string UpdateTiket(EventTicket _ticket)
{
using (EventrixDBDataContext dbd = new EventrixDBDataContext())
{
try
{
int isAvail = (from st in dbd.Ticket_Templates where st.eventid.Equals(_ticket._EventID) && st.Type.Equals(_ticket._Type) select st).Count();
if (isAvail == 0)
{
Ticket_Template toInsert = new Ticket_Template();
toInsert.Type = _ticket._Type;
toInsert.Credit = _ticket._Credit;
toInsert.Price = _ticket._Price;
toInsert.RefundPolicy = _ticket._Refund;
toInsert.StartDate = _ticket._StartDate;
toInsert.EndDate = _ticket._EndDate;
toInsert.eventid = _ticket._EventID;
dbd.Ticket_Templates.InsertOnSubmit(toInsert);
dbd.SubmitChanges();
return("success");
}
else //update available tickets
{
Ticket_Template toInsert = (from st in dbd.Ticket_Templates where st.eventid.Equals(_ticket._EventID) && st.Type.Equals(_ticket._Type) select st).First();
toInsert.Type = _ticket._Type;
toInsert.Credit = _ticket._Credit;
toInsert.Price = _ticket._Price;
toInsert.RefundPolicy = _ticket._Refund;
toInsert.StartDate = _ticket._StartDate;
toInsert.EndDate = _ticket._EndDate;
toInsert.eventid = _ticket._EventID;
dbd.SubmitChanges();
return("success");
}
}
catch (Exception)
{
return("failed");
}
}
}
public bool updateTicket(EventTicket _ticket)
{
try
{
using (EventrixDBDataContext dbd = new EventrixDBDataContext())
{
Ticket_Template toInsert = (from st in dbd.Ticket_Templates where st.eventid.Equals(_ticket._EventID) select st).First();
toInsert.Type = _ticket._Type;
toInsert.Credit = _ticket._Credit;
toInsert.Price = _ticket._Price;
toInsert.RefundPolicy = _ticket._Refund;
toInsert.StartDate = _ticket._StartDate;
toInsert.EndDate = _ticket._EndDate;
toInsert.eventid = _ticket._EventID;
// toInsert.G_ID = _ticket._GuestID;
dbd.SubmitChanges();
return(true);
};
}catch (Exception)
{
return(false);
}
}
