public async Task <TicketModel> EditTicket(TicketModel model)
{
var ticket = _mapper.Map <tblTicket>(model);
var result = _unitOfWork.TicketRepository.Update(ticket);
await _unitOfWork.Commit();
var mapped = _mapper.Map <TicketModel>(result);
return(mapped);
}
public ActionResult Edit([Bind(Include = "TicketID,EventTitle,TicketRow,TicketColumn")] TicketModel ticketmodel)
{
if (ModelState.IsValid)
{
db.Entry(ticketmodel).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ticketmodel));
}
/// <summary>
/// 生成带参数的二维码（永久二维码），本接口无须登录态即可调用。正确情况下，http 返回码是200，是一张图片，可以直接展示或者下载。
/// </summary>
/// <param name="scene_id">场景值ID，永久二维码时最大值为100000（目前参数只支持1--100000）</param>
/// <param name="access_token">access_token</param>
/// <returns>正确情况下，http 返回码是200，是一张图片，可以直接展示或者下载</returns>
public static string GetQrCode(int scene_id, string access_token)
{
TicketModel model = getTicket(TicketType.QR_LIMIT_SCENE, 0, scene_id, access_token);
if (null != model)
{
return(getQrCode(model.ticket));
}
return(string.Empty);
}
public TicketModel Add(TicketModel model)
{
using (var scope = _contextScopeFactory.Create())
{
var entity = _mapper.Map <Ticket> (model);
_repository.Add(entity);
_repository.Save();
return(model);
}
}
public ActionResult Edit([Bind(Include = "Id,titre,description,date,urlPhoto")] TicketModel ticketModel)
{
if (ModelState.IsValid)
{
db.Entry(ticketModel).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ticketModel));
}
public List <TicketModel> Payment(TicketModel ticket)
{
ticket.SeatNumbers = ticket.seats[0].ToString();
for (int i = 1; i < ticket.seats.Length; i++)
{
ticket.SeatNumbers = ticket.seats[i].ToString() + "," + ticket.SeatNumbers;
}
return(customerDAL.Payment(ticket));
}
public ActionResult Post([FromBody] TicketModel ticketModel)
{
var ticket = _mapper.Map <Ticket>(ticketModel);
ticket = _helpdekService.AddTicket(ticket);
if (ticket == null)
{
return(BadRequest());
}
return(CreatedAtAction("Get", new { id = ticket.ID }, ticket));
}
public void Add()
{
TicketModel Ticket = new TicketModel
{
ImageSource = @"H:\Good.png",
Prix = 10,
TicketId = 0
};
Tickets.Add(Ticket);
}
public async Task <TicketModel> Insert(TicketModel model)
{
var entity = _mapper.Map <Data.Entities.Ticket>(model);
entity.Id = 0;
await _unitOfWork.Ticket.InsertAsync(entity);
await _unitOfWork.SaveAsync();
return(_mapper.Map <TicketModel>(entity));
}
public TicketModel GetTicket(int id, int userId)
{
var ticketId = _ticketRepository.GetAll().FirstOrDefault(x => x.Id == id && x.UserId == userId);
TicketModel ticket = new TicketModel()
{
Id = ticketId.Id,
Ticket = _createTicket.CreateTicketList(ticketId.Ticket)
};
return(ticket);
}
public async Task <IActionResult> Update(TicketModel model)
{
var result = await _ticketService.Update(model);
if (result == Guid.Empty)
{
return(BadRequest("Ticket not updated"));
}
return(Ok(result));
}
public async Task <IActionResult> Create([Bind("Id,Ticketstatus,Title,Description,RaisedDate,ClosedDate")] TicketModel ticketModel)
{
if (ModelState.IsValid)
{
_context.Add(ticketModel);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(ticketModel));
}
public async Task <Document> AddTicket(TicketModel ticket)
{
string databaseName = "FirstResponse";
string collectionName = "Tickets";
ResourceResponse <Document> result = await _client.CreateDocumentAsync(
UriFactory.CreateDocumentCollectionUri(databaseName, collectionName),
ticket);
return(result.Resource);
}
public IActionResult Create([Bind("TicketNo,TicDate,VendorId,VendorName,TotalAmt,TaxAmt,Note,ScrapValue,ApplyDate,CancelDate")] TicketModel ticketModel)
{
if (ModelState.IsValid)
{
_context.Tickets.Add(ticketModel);
_context.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ticketModel));
}
public void FillOutTicket(TicketModel ticket)
{
TicketDTO newTicket = new TicketDTO()
{
SessionId = ticket.SessionId,
UserId = ticket.UserId,
Numbers = ticket.Numbers
};
_ticketRepository.Add(newTicket);
}
public IHttpActionResult PostTicket([Required] TicketModel ticketModel)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
var existeOEstacionamento = Db.Estacionamentos.Any(e => e.Id == ticketModel.Estacionamento.Id);
if (!existeOEstacionamento)
{
return(NotFound());
}
var userDeviceExistente = Db.UserDevices.Where(t => t.Token == ticketModel.UserDeviceToken).SingleOrDefault();
var userDivive = userDeviceExistente ?? new Entity.User.UserDevice {
Id = Guid.NewGuid(), Token = ticketModel.UserDeviceToken
};
if (userDeviceExistente == null)
{
Db.UserDevices.Add(userDivive);
}
var tempoDeInicioInvalido = ticketModel.DataInicioDoSlot <= DateTimeOffset.Now.AddDays(-1);
if (tempoDeInicioInvalido)
{
return(BadRequest());
}
////////////////
var novoTicket = new Ticket
{
Id = Guid.NewGuid(),
CreatedAt = DateTimeOffset.Now,
EstacionamentoId = ticketModel.Estacionamento.Id,
PlacaDoCarro = ticketModel.PlacaDoCarro,
UserDeviceToken = ticketModel.UserDeviceToken,
DataInicioDoSlot = ticketModel.DataInicioDoSlot,
DataFimDoSlot = ticketModel.DataInicioDoSlot.Value.AddHours(ticketModel.IntervaloComprado.Value),
PrecoPagoEmCentavos = ticketModel.PrecoAPagarEmCentavos,
IntervaloComprado = ticketModel.IntervaloComprado,
};
novoTicket.DetalhePagamento = Cobrar(ticketModel, userDivive);
Db.Ticket.Add(novoTicket);
Db.SaveChanges();
return(Ok(novoTicket.Id));
}
public BookTicket(object ticket)
{
InitializeComponent();
ticketModel = ticket as TicketModel;
_firebaseDatabase = DependencyService.Get <IFirebaseDatabaseService>();
_firebaseAuth = DependencyService.Get <IFirebaseAuthService>();
ViewTicket(ticketModel);
}
private void ViewTicket(TicketModel ticketModel)
{
airline.Text = ticketModel.Airline;
image.Source = ticketModel.Image;
to.Text = ticketModel.To;
from.Text = ticketModel.From;
code.Text = ticketModel.Code;
loader.IsVisible = false;
container.IsVisible = true;
}
/////////////////////////////// TICKET ///////////////////////////////////////////
///////////////// TICKET ///////////////////////////
//////////////////////////////////////////////////////////////////////////////////
public ActionResult InserirTicket()
{
var model = new TicketModel();
model.TicketEntity = new TicketEntity();
model.TicketEntity.UsuarioId = this.UsuarioId;
model.TicketEntity.DataCadastro = DateTime.Now;
return(View("PrincipalTicket", model));
}
/// <summary>Read quequed tickets</summary>
public static bool TryReadQueueUsers(ConnectionContext connection, TicketModel sourceTicket, TicketModel destinationTicket, out int[] values)
{
string query = $"SELECT TicketQueue.UserID " +
$"FROM TicketQueue WITH (NOLOCK) " +
$"JOIN Users WITH (NOLOCK) on Users.userid = TicketQueue.userid " +
$"LEFT JOIN TicketQueue TicketQueue2 WITH(NOLOCK) on TicketQueue2.userid = TicketQueue.userid and TicketQueue2.ticketid = {destinationTicket.TicketID} " +
$"WHERE TicketQueue.ticketid ={sourceTicket.TicketID} and TicketQueue2.TicketQueueID IS NULL and MarkDeleted =0";
values = connection._db.ExecuteQuery <int>(query).ToArray();
return(values.Length > 0);
}
public static async Task UpdateTicket(this AppDbContext db, TicketModel model)
{
if (await model.Validate(db))
{
var ticket = await db.Tickets.FindAsync(model.id);
ticket.Name = model.name;
ticket.TicketNumber = model.ticketNumber;
await db.SaveChangesAsync();
}
}
public ActionResult SalvarArquivo(IEnumerable <HttpPostedFileBase> files, TicketAnexoEntity entity)
{
TicketModel model2 = new TicketModel();
TicketAnexoModel model = new TicketAnexoModel();
model.TicketAnexoEntity = entity;
if (files != null)
{
foreach (var file in files)
{
string fileName = "";
string path = Server.MapPath("~/Arquivos/Ticket/Anexo/");
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
// Verify that the user selected a file
if (file != null && file.ContentLength > 0)
{
// extract only the fielname
fileName = Path.GetFileNameWithoutExtension(file.FileName) + "-" + entity.TicketId + Path.GetExtension(file.FileName);
path = Path.Combine(path, fileName);
if (System.IO.File.Exists(path))
{
path = GetFileName(path);
fileName = Path.GetFileName(path);
}
file.SaveAs(path);
if (ModelState.IsValid)
{
var entity2 = new TicketAnexoEntity();
entity2.TicketId = entity.TicketId;
entity2.Observacao = entity.Observacao;
entity2.CaminhoArquivo = "~/Arquivos/Ticket/Anexo/" + fileName;
// entity2.TpArq = Path.GetExtension(fileName);
new TicketAnexoBusiness().Salvar(entity2, this.UsuarioId);
}
}
}
}
model.TicketAnexoEntity = new TicketAnexoEntity()
{
TicketId = entity.TicketId
};
//context.TicketAnexoEntity.Where(a => a.TicketId == entity.TicketId)
model.TicketAnexoList = TicketBusiness.PesquisarAnexoPorTicket(entity.TicketId).ToList();
return(PartialView("_TicketAnexo", model));
}
public ActionResult Create([Bind(Include = "Id,titre,description,date,urlPhoto")] TicketModel ticketModel)
{
if (ModelState.IsValid)
{
db.TicketModels.Add(ticketModel);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ticketModel));
}
public static int RemoveTicket(string userId, string projectName, int ticketId)
{
TicketModel data = new TicketModel
{
TicketId = ticketId
};
string sql = $@"delete from dbo.{userId}@{projectName} where Id = @TicketId;";
return(SqlDataAccess.SaveData(sql, data));
}
public TicketModel map(TicketDTO ticketdto)
{
TicketModel model = new TicketModel();
model.setID(ticketdto.getID());
model.setShowID(ticketdto.getShowID());
model.setRow(ticketdto.getRow());
model.setColumn(ticketdto.getColumn());
return(model);
}
public TicketDTO map(TicketModel ticketmodel)
{
TicketDTO dto = new TicketDTO();
dto.setID(ticketmodel.getID());
dto.setShowID(ticketmodel.getShowID());
dto.setRow(ticketmodel.getRow());
dto.setColumn(ticketmodel.getColumn());
return(dto);
}
public static Tickets ToTicketsEntity(this TicketModel ticketModel)
{
return(new Tickets
{
TicketPurchaseId = ticketModel.TicketPurchaseId,
SectionId = ticketModel.SectionId,
EventId = ticketModel.EventId,
RowNumber = ticketModel.RowNumber,
SeatNumber = ticketModel.SeatNumber
});
}
public async Task <IActionResult> AddTicket(TicketModel ticket)
{
try
{
return(new JsonResult(await _ticketrepo.Insert(ticket)));
}
catch (Exception ex)
{
_logger.LogError("", ex);
return(new JsonResult(ResponseModel.ServerInternalError(data: ex)));
}
}
//
// GET: /APITickets/
public IEnumerable <TicketModel> Get(int id)
{
TicketModel objModel = new TicketModel();
TicketService objService = new TicketService();
List <TicketModel> lstticker = new List <TicketModel>();
int rid = 2;
lstticker = objService.getTicket(id, rid);
objModel.ListTicket = new List <TicketModel>();
objModel.ListTicket.AddRange(lstticker);
return(objModel.ListTicket.Where(m => m.CreatedBy == id).ToList());
}
protected override void AddTicketToMap(TicketModel ticket)
{
var annotation = new TicketAnnotation(new
CLLocationCoordinate2D
{
Latitude = ticket.Latitude,
Longitude = ticket.Longitude
},
ticket);
_nativeMap.AddAnnotation(annotation);
}
