private String GetReference(Tickets ticket)
{
string sReference;
Tickets dbEntry = Tickets.OrderByDescending(x => x.Reference).FirstOrDefault() ;
if (dbEntry != null)
{
sReference = dbEntry.Reference;
int nRef = Convert.ToInt16(sReference.Substring(4,6));
if (nRef != 999999)
{
nRef += 1;
sReference = sReference.Substring(0,3) + "-" + nRef.ToString().PadLeft(6, '0');
}
else
{
}
}
else
{
sReference = "AAA-000001";
}
return sReference;
}
public void populateDb()
{
Events events = new Events()
{
Name = "Black Coffee Tirane",
EventDate = DateTime.ParseExact("2019-04-08 23:30:00", "yyyy-MM-dd HH:mm:ss",
System.Globalization.CultureInfo.InvariantCulture),
Tickets = new List <Tickets>()
};
// Random rnd = new Random();
// events.Tickets.Add(new Tickets(){
// Barcode = "3850322007099",
// IsActivated = false
// });
// int x = 1;
// while(x<50){
// long barcode = rnd.Next(10000000,99999999);
// foreach(Tickets tickets in events.Tickets){
// if(tickets.Barcode.Equals(barcode+"")){
// continue;
// }
// }
// var ticket = new Tickets(){
// Barcode = barcode.ToString(),
// IsActivated = false
// };
// events.Tickets.Add(ticket);
// x++;
// }
Console.WriteLine(fakeBarcodes.Length + "");
for (int x = 0; x < fakeBarcodes.Length; x++)
{
var ticket = new Tickets()
{
Barcode = fakeBarcodes[x],
IsActivated = false
};
events.Tickets.Add(ticket);
x++;
}
db.Events.Add(events);
db.SaveChanges();
}
public string SaveCheckboxWithoutAkcizaValue(string boolchecked, string goodsid, string appkey, string ticketid, string userid, string userip, string pagename)
{
if (appkey != Globals.Settings.AppServiceSecureKey)
{
return("invalid app key");
}
var goods = new Goods {
ID = Convert.ToInt32(goodsid), WithoutAkciza = Convert.ToInt32(boolchecked)
};
goods.Update(Convert.ToInt32(userid), userip, pagename); //1
var ticket = new Tickets {
ID = Convert.ToInt32(ticketid)
};
ticket.GetById(); //2
var newGoods = new Goods {
TicketFullSecureID = ticket.FullSecureID
};
var goodsDataSet = newGoods.GetAllItems("ID", "ASC", "TicketFullSecureID"); //3
var goodsList = (from DataRow row in goodsDataSet.Tables[0].Rows
select new GoodsFromAPI
{
Description = row["Description"].ToString(),
Number = Convert.ToInt32(row["Number"].ToString()),
WithoutAkciza = Convert.ToInt32(row["WithoutAkciza"].ToString())
}).ToList();
var profile = new UsersProfiles {
ID = Convert.ToInt32(ticket.UserProfileID)
};
profile.GetById(); //4
var agreedAccessedCost = ticket.AgreedCost != 0 ? (ticket.AgreedCost).ToString() : (ticket.AssessedCost).ToString();
var gruzobozCost = Calculator.Calculate(goodsList, Convert.ToInt32(ticket.CityID), Convert.ToInt32(ticket.UserID), Convert.ToInt32(ticket.UserProfileID), profile.TypeID.ToString(), agreedAccessedCost);
if (gruzobozCost != "0" && !String.IsNullOrEmpty(gruzobozCost))
{
ticket.GruzobozCost = Convert.ToDecimal(gruzobozCost);
ticket.Update(Convert.ToInt32(userid), userip, pagename); //5
}
return("OK");
}
private List <TicketExceptions> LoadVoidCancelledTickets()
{
objCashDeskManager = CashDeskManagerBusinessObject.CreateInstance();
System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart) delegate
{
lvVoidCancelled.Items.Clear();
});
List <string> lstPositionstoDisplay = objCashDeskManager.FillListOfFilteredPositions(RouteNumber);
Tickets oTickets = new Tickets();
oTickets.EndDate = EndDate;
oTickets.StartDate = StartDate;
oTickets.IsLiability = false;
oTickets.BarCode = "%";
oTickets.Type = "B";
oTickets.UserNo = UserNo;
System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart) delegate
{
prgVoidcancelled.Value += 50;
});
List <TicketExceptions> lstVoidCancelled = objCashDeskManager.GetTicket_VoidnExpired(oTickets, lstPositionstoDisplay);
if (lstVoidCancelled != null)
{
decimal ExceptionTotal = 0;
TicketExceptions Total = new TicketExceptions();
Total.PrintDate = "Total";
foreach (TicketExceptions exep in lstVoidCancelled)
{
ExceptionTotal += (decimal)exep.Value;
}
Total.Value = (double)Decimal.Round(ExceptionTotal, 2);
// Total.Amount = Total.Value.ToString("###0.#0");
Total.Amount = CurrencySymbol + "" + Convert.ToDecimal(ExceptionTotal).GetUniversalCurrencyFormat();
lstVoidCancelled.Insert(0, Total);
System.Windows.Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, (ThreadStart) delegate
{
prgVoidcancelled.Value += 50;
});
}
return(lstVoidCancelled);
}
// GET: TicketAttachments/Create
public ActionResult Create(Tickets tickets)
{
ViewBag.UserId = new SelectList(db.Users, "Id", "FirstName");
ViewBag.TicketId = new SelectList(db.Tickets, "Id", "Title");
var ticketAttachment = new TicketAttachments();
var bp = db.Tickets.Find(ticketAttachment.TicketId);
//var project = new Projects();
//Tickets tickets = db.Tickets.Find(id);
//ticket.TicketId = id;
//ticket.UserId = User.Identity.GetUserId();
var user = db.Users.Find(User.Identity.GetUserId());
if (User.IsInRole("Developer"))
{
if (!(tickets.AssignedToId == user.Id))
{
return(RedirectToAction("Login", "Account"));
}
}
if (User.IsInRole("ProjectManager"))
{
if (!(tickets.Project.PManagerID == user.Id))
{
return(RedirectToAction("Login", "Account"));
}
}
if (User.IsInRole("Submitter"))
{
if (!(tickets.OwnerUserId == user.Id))
{
return(RedirectToAction("Login", "Account"));
}
}
//ViewBag.TicketId = new SelectList(db.Tickets, "Id", "Title");
//ViewBag.UserId = new SelectList(db.Users, "Id", "FirstName");
//return View(ticket);
if (!User.Identity.IsAuthenticated)
{
return(RedirectToAction("Login", "Account"));
}
return(View());
}
public ActionResult Edit([Bind(Include = "Id,Title,Description,Created,Updated,ProjectId,TicketTypeId,TicketPriorityId,TicketStatusId,OwnerUserId,AssignedToId")] Tickets model)
{
var user = db.Users.Find(User.Identity.GetUserId());
ProjectHelper HistoryHelp = new ProjectHelper(db);
var tickets = db.Tickets.Find(model.Id);
var noty = new TicketNotifications();
noty.open = false;
if (!(tickets.Title == model.Title) || (tickets.TicketPriorityId == model.TicketPriorityId) || (tickets.TicketStatusId == model.TicketStatusId) ||
(tickets.AssignedToId == model.AssignedToId) || (tickets.ProjectId == model.ProjectId) || (tickets.TicketTypeId == model.TicketTypeId))
{
HistoryHelp.AddHistory(tickets.Id, user.Id, tickets.Title, model.Title, "Title");
HistoryHelp.AddHistory(tickets.Id, user.Id, tickets.TicketPriorityId.ToString(), model.TicketPriorityId.ToString(), "TicketPriority");
HistoryHelp.AddHistory(tickets.Id, user.Id, tickets.TicketStatusId.ToString(), model.TicketStatusId.ToString(), "TicketStatus");
HistoryHelp.AddHistory(tickets.Id, user.Id, tickets.TicketTypeId.ToString(), model.TicketTypeId.ToString(), "TicketType");
HistoryHelp.AddHistory(tickets.Id, user.Id, tickets.ProjectId.ToString(), model.ProjectId.ToString(), "Project");
HistoryHelp.AddHistory(tickets.Id, user.Id, tickets.Description, model.Description, "Description");
HistoryHelp.AddHistory(tickets.Id, user.Id, tickets.AssignedToId, model.AssignedToId, "AssignedTo");
HistoryHelp.AddNoty(tickets.Id, user.Id, noty.open);
}
tickets.TicketPriorityId = model.TicketPriorityId;
tickets.TicketStatusId = model.TicketStatusId;
tickets.OwnerUserId = user.Id;
tickets.Created = tickets.Created = DateTime.Now;
db.Tickets.Add(model);
//tickets.Id = model.Id;
if (ModelState.IsValid)
{
db.Entry(tickets).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("myIndex", "Tickets"));
}
//ViewBag.AssignedToId = new SelectList(db.Users, "Id", "FirstName", tickets.AssignedToId);
//ViewBag.OwnerUserId = new SelectList(db.Users, "Id", "FirstName", tickets.OwnerUserId);
ViewBag.ProjectId = new SelectList(db.Projects, "Id", "Name", tickets.ProjectId);
ViewBag.TicketPriorityId = new SelectList(db.TicketPriorities, "Id", "Name", tickets.TicketPriorityId);
ViewBag.TicketStatusId = new SelectList(db.TicketStatuses, "Id", "Name", tickets.TicketStatusId);
ViewBag.TicketTypeId = new SelectList(db.TicketTypes, "Id", "Name", tickets.TicketTypeId);
return(View("myIndex", "Tickets"));
}
public static string GetTickets(RestCommand command)
{
string xml = "";
if (command.Filters["TicketTypeID"] != null)
{
try
{
ReportTicketsView tickets = new ReportTicketsView(command.LoginUser);
int ticketTypeID = int.Parse(command.Filters["TicketTypeID"]);
TicketType ticketType = TicketTypes.GetTicketType(command.LoginUser, ticketTypeID);
if (ticketType.OrganizationID != command.Organization.OrganizationID)
{
throw new Exception();
}
tickets.LoadByTicketTypeID(ticketTypeID);
xml = tickets.GetXml("Tickets", "Ticket", true, command.Filters);
}
catch (Exception ex)
{
throw new RestException(HttpStatusCode.NotAcceptable, "Invalid TicketTypeID to filter.", ex);
}
}
else
{
TicketTypes ticketTypes = new TicketTypes(command.LoginUser);
ticketTypes.LoadByOrganizationID(command.Organization.OrganizationID);
ReportTicketsView tickets = new ReportTicketsView(command.LoginUser);
XmlTextWriter writer = Tickets.BeginXmlWrite("Tickets");
foreach (TicketType ticketType in ticketTypes)
{
tickets.LoadByTicketTypeID(ticketType.TicketTypeID);
//writer.WriteStartElement(ticketType.Name);
foreach (DataRow row in tickets.Table.Rows)
{
tickets.WriteXml(writer, row, "Ticket", true, command.Filters);
}
//writer.WriteEndElement();
}
xml = Tickets.EndXmlWrite(writer);
}
//return tickets.GetXml("Tickets", "Ticket", command.Filters["TicketTypeID"] != null, command.Filters);
return(xml);
}
//public bool InactivarTiquete(int usuario, string identificacion, string pass)
//{
// try
// {
// var temp = from l in entities.Tickets
// where l.idUsuario == usuario && l.Estado == true
// select l;
// List<Tickets> t = temp.ToList<Tickets>();
// if (t.Count > 0)
// {
// if (t[0].Fecha < DateTime.Now)
// {
// Tickets nuevo = t.First<Tickets>(x => x.idUsuario == usuario && x.Ticket == tiquet);
// nuevo.Estado = false;
// int n = entities.SaveChanges();
// //crearTicket(usuario);
// if (n > 0)
// {
// return true;
// }
// else
// {
// return false;
// }
// }
// else
// {
// int horaAactual = DateTime.Now.Hour;
// int horaInicio = t[0].HoraInicio.Hour;
// int MinutosActual = DateTime.Now.Minute;
// int MinutosInicio = t[0].HoraInicio.Minute;
// int tiempoEstablecido = CantidadMinutos();
// if ((horaAactual - horaInicio) == 0 && (MinutosInicio - MinutosActual) > tiempoEstablecido)
// {
// Tickets nuevo = t.First<Tickets>(x => x.idUsuario == usuario && x.Ticket == tiquet);
// nuevo.Estado = false;
// int n = entities.SaveChanges();
// //crearTicket(usuario);
// if (n > 0)
// {
// return true;
// }
// else
// {
// return false;
// }
// }
// else
// {
// return false;
// }
// }
// }
// else
// {
// return false;
// }
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
public bool InactivarTiquete(int usuario)
{
try
{
Tickets ticket = obtenerTicket(usuario);
if (ticket.Fecha < DateTime.Now)
{
Tickets nuevo = ticket;
nuevo.Estado = false;
int n = entities.SaveChanges();
if (n > 0)
{
return(true);
}
else
{
return(false);
}
}
else
{
DateTime horaActual = DateTime.Now.ToLocalTime();
if (ticket.HoraInicio < horaActual && ticket.HoraFinal > horaActual)
{
Tickets nuevo = ticket;
nuevo.Estado = false;
int n = entities.SaveChanges();
if (n > 0)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
private void InitTickets()
{
Ticket ticket1 = new Ticket();
Ticket ticket2 = new Ticket();
ticket1.Id = 1;
ticket1.Coupons[0] = Coupons.Find(f => f.Id == 1);
ticket1.Coupons[1] = Coupons.Find(f => f.Id == 3);
ticket2.Id = 2;
ticket2.Coupons[0] = Coupons.Find(f => f.Id == 2);
Tickets.Add(ticket1);
Tickets.Add(ticket2);
Coupons.Find(c => c.Id == 1).Ticket = ticket1;
Coupons.Find(c => c.Id == 2).Ticket = ticket2;
Coupons.Find(c => c.Id == 3).Ticket = ticket1;
}
//get active tickets from webservice
public void getActiveTicketsFromWebservice()
{
//clear list
Tickets.Clear();
Webservice Service = new Webservice();
if (_ParkingPlaceForTicketSelect != null)
{
Service.getActiveTickets(_ParkingPlaceForTicketSelect.id);
for (int i = 0; i < Service.TicketList.Count; i++)
{
Tickets.Add(Service.TicketList.ElementAt(i));
}
}
}
public async Task <IActionResult> Create([Bind("Id,Name,ContractId,AssignedTo,Description,DateFrom,ContactId,TicketTypeId,EstimatedHours,CreatedBy,TicketImpactId,TicketUrgencyId,TicketPriority")] Tickets tickets)
{
if (ModelState.IsValid)
{
_context.Add(tickets);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["ContactId"] = new SelectList(_context.Contacts, "Id", "Email", tickets.ContactId);
ViewData["ContractId"] = new SelectList(_context.Contracts, "Id", "Name", tickets.ContractId);
ViewData["TicketImpactId"] = new SelectList(_context.TicketImpacts, "Id", "Name", tickets.TicketImpactId);
ViewData["TicketTypeId"] = new SelectList(_context.TicketTypes, "Id", "Name", tickets.TicketTypeId);
ViewData["TicketUrgencyId"] = new SelectList(_context.TicketUrgencies, "Id", "Name", tickets.TicketUrgencyId);
return(View(tickets));
}
private async void UpdateTicket()
{
try
{
var result = await _service.UpdateAsync(SelectedTicket);
result.Flight = await new FlightService().GetAsync(result.FlightId);
Tickets.Remove(SelectedTicket);
Tickets.Insert(0, result);
}
catch (System.InvalidOperationException ex)
{
await _dialogService.ShowMessage(ex.Message, "Error");
}
}
public ActionResult Edit([Bind(Include = "ID,Problema,Descricao,TempoDispendido,DataAberturaTicket,DataFechoTicket,TecnicoFK,ClienteFK,CategoriaFK,StatusFK,TipoFK,PrioridadeFK")] Tickets tickets)
{
if (ModelState.IsValid)
{
db.Entry(tickets).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CategoriaFK = new SelectList(db.Categorias, "ID", "Categoria", tickets.CategoriaFK);
ViewBag.ClienteFK = new SelectList(db.Clientes, "ID", "Nome", tickets.ClienteFK);
ViewBag.PrioridadeFK = new SelectList(db.Prioridades, "ID", "Desc_Prioridade", tickets.PrioridadeFK);
ViewBag.StatusFK = new SelectList(db.Estados, "ID", "Desc_Status", tickets.StatusFK);
ViewBag.TecnicoFK = new SelectList(db.Tecnicos, "ID", "Nome", tickets.TecnicoFK);
ViewBag.TipoFK = new SelectList(db.Tipos, "ID", "Desc_Tipo", tickets.TipoFK);
return(View(tickets));
}
public MensajesTickets ActualizarTicket([FromBody] Tickets infoTicket)
{
MensajesTickets msjTickets = new MensajesTickets();
ActualizacionesTickets objActualizacionesTicketsBD = new ActualizacionesTickets();
msjTickets = objActualizacionesTicketsBD.ActualizacionTicket(infoTicket);
if (msjTickets.OperacionExitosa)
{
Logs.Info(string.Format("Actualización de Ticket con ID: {0} realizada exitosamente.", infoTicket.IdTicket));
}
else
{
Logs.Error(msjTickets.MensajeError);
}
return(msjTickets);
}
/*!
* \brief Remove a ticket from the lottery.
*
* If the ticket has not been sold no action will be made.
* Otherwise, the ticket's number will be added to the availible numbers again,
* and if it was a winning number it will be removed from the list of winners as well.
*/
public void RemoveTicket(Ticket ticket)
{
var target = Tickets.Find(T => T.LotteryNumber == ticket.LotteryNumber);
if (target == null)
{
return;
}
// Remove the number from winners (if there) and add it to the availible numbers again,
// before removing it from the list of sold tickets.
WinningLotteryNumbers.Remove(target.LotteryNumber);
++NumLotteryNumbersLeft;
LotteryNumbers[target.LotteryNumber] = target.LotteryNumber;
Tickets.Remove(target);
}
/// <summary>
/// method to get all approvers of given ticket
/// </summary>
/// <param name="ticketId">ticket id of which approvers need to be fetched</param>
/// <returns>list of all approvers of given ticket</returns>
public JsonResult GetApproversOfTicket(int ticketId)
{
try
{
Tickets Ticket = ticketCntrl.GetTicketObjectData(ticketId);
if (Ticket != null)
{
return(Json(Ticket.Approvals, JsonRequestBehavior.AllowGet));
}
}
catch (Exception)
{
throw;
}
return(null);
}
public Report(Ticket[] tickets)
{
if (tickets.Length == 0)
{
return;
}
Tickets = tickets.Select(ticket => new TicketResult
{
ExecutionTime = ticket.ExecutionTime,
Report = this,
Title = ticket.Title,
Id = ticket.Id,
Status = ticket.Status.ToString()
}).ToArray();
AverageExecutionTime = new TimeSpan(Convert.ToInt64(Tickets.Average(result => result.ExecutionTime.Ticks)));
}
public string CreateTicket(Tickets Tickets)
{
try
{
string ticketDetails = "state=" + Tickets.state + "&priority=" + Tickets.priority + "&name=" + Tickets.name + "&issue_c=" + Tickets.issue + "&description=" + Tickets.description + "&type=" + Tickets.type + "&status=" + Tickets.status + "&account_id=" + ConfigurationManager.AppSettings["TicketaccountId"].ToString() + ""
+ "&ticket_created_by_c=" + Tickets.ticketCreatedBy + "&Submit=Submit&campaign_id=" + ConfigurationManager.AppSettings["TicketCampaignId"].ToString() + "&assigned_user_id=1&moduleDir=Cases&client_id_address=117.223.141.186&dup_checked=1";
var task = new Thread(() => pushtoCRM(ticketDetails));
task.Start();
return("Success");
}
catch (Exception ex)
{
Log.Error("" + ex);
return("Something went wrong! Error:" + ex.Message);
}
}
public ActionResult Create([Bind(Include = "Id,Title,Description,AssignId,TicketTypeId,ProjectId,TicketPriorityId,TicketStatusId")] Tickets tickets)
{
if (ModelState.IsValid)
{
tickets.Created = DateTime.Now;
tickets.TicketStatusId = 1;
tickets.CreatorId = User.Identity.GetUserId();
db.Tickets.Add(tickets);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ProjectId = new SelectList(db.Projects, "Id", "Name", tickets.ProjectId);
ViewBag.TicketPriorityId = new SelectList(db.TicketPriorities, "Id", "Title", tickets.TicketPriorityId);
ViewBag.TicketTypeId = new SelectList(db.TicketTypes, "Id", "Title", tickets.TicketTypeId);
return(View(tickets));
}
public ActionResult AddTicket(AddTicketViewModel model)
{
model.Categories = unitOfWork.Categories.GetListCategories();
if (ModelState.IsValid)
{
var ticket = new Tickets { Author = User.Identity.GetUserId(), Title = model.Title, Priority = model.Priority, Description = model.Description, Screenshot = model.Screenshot, Category = model.Category };
unitOfWork.Tickets.Create(ticket);
unitOfWork.Save();
return RedirectToAction("Index", "Home");
}
return View(model);
}
public async Task <ActionResult> CreateTicket([FromBody] Tickets ticket)
{
AuthenticateAndGetTokenAndGetFacade(out LoginToken <Administrator>
token_admin, out LoggedInAdministratorFacade facade);
try
{
await Task.Run(() => facade.CreateNewTicket(token_admin, ticket));
}
catch (Exception ex)
{
return(StatusCode(500, $"{{ error: \"{ex.Message}\" }}"));
}
return(Ok());
}
public ActionResult Create(Tickets obj)
{
try
{
using (TicketDomContext context = new TicketDomContext())
{
context.Tickets.Add(obj);
context.SaveChanges();
return(RedirectToAction("Index"));
}
}
catch
{
return(View());
}
}
public async Task <ActionResult> IndexAsync(long tranId)
{
if (tranId <= 0)
{
return(this.HttpNotFound(string.Format(I18N.TheTicketCouldNotBeFound, tranId)));
}
var model = await Tickets.GetTicketViewModelAsync(this.Tenant, tranId).ConfigureAwait(true);
if (model.View == null)
{
return(this.HttpNotFound(string.Format(I18N.TheTicketCouldNotBeFound, tranId)));
}
return(this.View(this.GetRazorView <AreaRegistration>("Ticket/Index.cshtml", this.Tenant), model));
}
public void LoadCommentHistory(string appkey, string ticketid)
{
if (appkey != Globals.Settings.AppServiceSecureKey)
{
Context.Response.Write("invalid app key");
}
var ticket = new Tickets()
{
ID = Convert.ToInt32(ticketid)
};
ticket.GetById();
Context.Response.ContentType = "text/plain; charset=UTF-8";
Context.Response.Write(WebUtility.HtmlDecode(ticket.Comment));
}
private void LoadDatabase()
{
using (var stream = File.OpenText(DatabaseFile.FullName))
{
var reader = new JsonTextReader(stream);
var database = new JsonSerializer().Deserialize <DatabaseContainer>(reader);
Meta = database.Meta;
Projects.Load(this, database.Projects);
Features.Load(this, database.Features);
Sprints.Load(this, database.Sprints);
Tickets.Load(this, database.Tickets);
reader.Close();
}
}
protected void SearchAsync()
{
List <Ticket> temp = Tickets.ToList();
Tickets.Clear();
if (string.IsNullOrWhiteSpace(SearchFilter))
{
temp.Clear();
UpdateDataAsync();
}
else
{
Tickets = new ObservableCollection <Ticket>(temp.Where(s => s.FlightNumber.StartsWith(SearchFilter, StringComparison.CurrentCultureIgnoreCase)).ToList());
}
RaisePropertyChanged(nameof(Tickets));
}
public static String SecureIDOrFullSecureID(string id)
{
var ticket = new Tickets {
ID = Convert.ToInt32(id)
};
ticket.GetById();
if (!String.IsNullOrEmpty(ticket.FullSecureID))
{
return(ticket.FullSecureID);
}
else
{
return(ticket.SecureID);
}
}
void btnVarios_Click(object sender, RoutedEventArgs e)
{
var tickets = Tickets.GetTicketPorTablaYFecha("Facturas", DateTime.Now);
var contexto = new NotaFiscalBoliviaPadraoERPOut_v1_Contexto();
contexto.Log += Contexto_Log;
foreach (var ticket in tickets)
{
contexto.Ticket = ticket.Ticket;
var xml = ticket.Valor;
var aNotas = contexto.GetNotaFiscalFromXML(xml);
contexto.GrabarNotasFiscales(aNotas);
Console.WriteLine(xml);
}
}
public static String GoodsStringFromTicketID(string id)
{
var ticket = new Tickets {
ID = Convert.ToInt32(id)
};
ticket.GetById();
var result = String.Empty;
var goods = new Goods {
TicketFullSecureID = ticket.FullSecureID
};
var ds = goods.GetAllItems("ID", "ASC", "TicketFullSecureID");
result = ds.Tables[0].Rows.Cast <DataRow>().Aggregate(result, (current, row) => current + (row["Description"] + ", " + row["Model"] + ", " + row["Number"] + "шт.;<br/>"));
return(result);
}
public async Task <ActionResult> IndexAsync(long tranId)
{
if (tranId <= 0)
{
return(this.HttpNotFound($"The ticket {tranId} could not be found."));
}
var model = await Tickets.GetTicketViewModelAsync(this.Tenant, tranId).ConfigureAwait(true);
if (model.View == null)
{
return(this.HttpNotFound($"The ticket {tranId} could not be found."));
}
return(this.View(this.GetRazorView <AreaRegistration>("Ticket/Index.cshtml", this.Tenant), model));
}
public Tickets PurchaseTicket(LoginToken <Customer> token, Flights flight)
{
Tickets ticket = new Tickets();
if (token != null)
{
if (!(token.User.ID).Equals(ticket.CustomerID) && (ticket.FlightID).Equals(flight.ID) && flight.RemainingTickets <= 0)
{
_flightDAO.Add(flight);
flight.RemainingTickets--;
return(_ticketDAO.Get(ticket.ID));
}
Console.WriteLine($"No remaining tickets or you already purchase ticket");
}
return(null);
}
static void Main(string[] args)
{
Booking b = new Booking();
Booking b1 = new Booking();
Booking b3 = new Booking();
List<Booking> listb = new List<Booking>();
List<Tickets> listt = new List<Tickets>();
Tickets t = new Tickets();
List<AttractionObj> lista = new List<AttractionObj>();
Console.WriteLine("testclient started");
ServiceattractionClient AttractionProxy = new ServiceattractionClient();
Console.WriteLine("get tickets test");
AttractionProxy.GetTickets(1);
Console.WriteLine("get tickets test succes");
// Console.WriteLine("getAvailableAttraction");
//AttractionProxy.GetAvailableAttractions(20, "12-12-2012", "12-25-2012", 12, 12, "England", "London", "mainsteert");
// AttractionProxy.GetAvailableAttractions(-2, null, "12-08-2012", -2, 12, "GB", null, null);
// AttractionProxy.GetAvailableAttractions(-2, null, null, -2, -2, null, null, null);
// Console.WriteLine("getAvailableAttraction succes");
// Console.WriteLine("BookAttraction test");
b = AttractionProxy.BookAttraction(1, 3, "Henk", "kaas", "12-12-2003", "NL", "Den Haag", "lutjestraat", "3939ND", "3", "neit", "nat");
b1 = AttractionProxy.BookAttraction(1, 3, "Piet", "kaas", "12-12-2003", "NL", "Den Haag", "lutjestraat", "3939ND", "3", "neit", "nat");
b3 = AttractionProxy.BookAttraction(1, 10, "Trien", "kaas", "12-12-2003", "NL", "Den Haag", "lutjestraat", "3939ND", "3", "neit", "nat");
listb.Add(b);
listb.Add(b3);
listb.Add(b1);
foreach (Booking bk in listb)
{
if (bk != null)
{
Console.WriteLine(bk.Bookingid);
}
else
{
Console.WriteLine("er is een fout opgetreden bij het boeken");
}
}
Console.WriteLine("BookAttraction succes");
}
public void ProcessQuery(Tickets query, string body)
{
using (var smtpClient = new SmtpClient())
{
smtpClient.EnableSsl = emailSettings.UseSsl;
smtpClient.Host = emailSettings.ServerName;
smtpClient.Port = emailSettings.ServerPort;
smtpClient.UseDefaultCredentials = false;
smtpClient.Credentials = new NetworkCredential(emailSettings.Username, emailSettings.Password);
if (emailSettings.WriteAsFile)
{
smtpClient.DeliveryMethod = SmtpDeliveryMethod.SpecifiedPickupDirectory;
smtpClient.PickupDirectoryLocation = emailSettings.FileLocation;
smtpClient.EnableSsl = false;
}
if (body == null)
{
StringBuilder bodyMail = new StringBuilder()
.AppendLine("The number of your query is:" + query.Reference)
.AppendLine("---")
.AppendLine("Query");
bodyMail.AppendLine(query.Subject);
bodyMail.AppendLine(query.Body);
body = bodyMail.ToString();
}
emailSettings.MailToAddress = query.Email;
MailMessage mailMessage = new MailMessage(
emailSettings.MailFromAddress, // From
emailSettings.MailToAddress, // To
"New order submitted!", // Subject
body.ToString()); // Body
if (emailSettings.WriteAsFile)
{
mailMessage.BodyEncoding = Encoding.ASCII;
}
smtpClient.Send(mailMessage);
}
}
public ActionResult SearchTicket()
{
List<Tickets> tks = new List<Tickets>();
int page = int.Parse(Request.QueryString["p"]);
IEnumerable<机票代售点> model = 机票代售点管理.查询机票代售点(0, 0, Query.EQ("所属供应商.用户ID", currentUser.Id)).Skip(10 * (page - 1)).Take(10);
long pager = 机票代售点管理.查询机票代售点(0, 0, Query.EQ("所属供应商.用户ID", currentUser.Id)).Count() / 10;
if ((机票代售点管理.查询机票代售点(0, 0, Query.EQ("所属供应商.用户ID", currentUser.Id)).Count() % 10) > 0)
{
pager++;
}
if (model != null)
{
foreach (var item in model)
{
if (item.审核数据.审核状态 == 审核状态.审核通过)
{
Tickets tk = new Tickets() { id = item.Id, name = item.代售点名称, address = item.地址, sq = item.所属地域.省份 + item.所属地域.城市 + item.所属地域.区县, Istrue = "通过审核" };
tks.Add(tk);
}
else
{
Tickets tk = new Tickets() { id = item.Id, name = item.代售点名称, address = item.地址, sq = item.所属地域.省份 + item.所属地域.城市 + item.所属地域.区县, Istrue = "未审核" };
tks.Add(tk);
}
}
}
JsonResult json = new JsonResult() { Data = new { dt = tks, p = pager } };
return Json(json, JsonRequestBehavior.AllowGet);
}
public string SaveTicket(Tickets ticket)
{
Tickets dbEntry = null;
if (ticket.Reference == null || (dbEntry = dbContext.Tickets.FirstOrDefault(x => x.Reference == ticket.Reference)) == null)
{
ticket.Responce = "";
ticket.SendResponce = false;
ticket.Reference = GetReference(ticket);
ticket.Statuses = dbContext.Statuses.FirstOrDefault(x => x.Id == 0);
ticket.Users = dbContext.Users.FirstOrDefault(x => x.Id == 0);
ticket.DepartmentId = ticket.Departments.Id;
ticket.Departments = dbContext.Departments.FirstOrDefault(x => x.Id == ticket.DepartmentId);
//ticket.listDepartment = new SelectList(dbContext.Departments.OrderBy(x => x.Id), "Id", "Department");
//ticket.listUser = new SelectList(dbContext.Users.OrderBy(x => x.Id), "Id", "Name");
//ticket.listStatus = new SelectList(dbContext.Statuses.OrderBy(x => x.Id), "Id", "Status");
dbContext.Tickets.Add(ticket);
}
else
{
//dbEntry.DepartmentId = 1;
ticket.Statuses = dbContext.Statuses.FirstOrDefault(x => x.Id == ticket.Statuses.Id);
ticket.Users = dbContext.Users.FirstOrDefault(x => x.Id == ticket.Users.Id);
ticket.Departments = dbContext.Departments.FirstOrDefault(x => x.Id == ticket.Departments.Id);
dbEntry = dbContext.Tickets.FirstOrDefault(x => x.Id == ticket.Id);
dbEntry.Departments = ticket.Departments;
dbEntry.Statuses = ticket.Statuses;
dbEntry.Users = ticket.Users;
dbEntry.Email = ticket.Email;
if(dbEntry.DataMail == null)
dbEntry.DataMail = DateTime.Today;
dbEntry.Subject = ticket.Subject;
dbEntry.Responce = ticket.Responce;
dbEntry.Reference = ticket.Reference;
//dbContext.Tickets.Add(dbEntry);
}
dbContext.SaveChanges();
return ticket.Reference;
}
