// Método para insertar venta
private void btInsertBuy_Click(object sender, EventArgs e)
{
bool isValid = ValidateField();
if (isValid)
{
SellTicket sellTicket = new SellTicket()
{
Amount = Convert.ToDecimal(this.txtInsertAmount.Text),
Price = Convert.ToDecimal(this.txtInsertTotal.Text),
SellTicketDate = DateTime.Parse(this.dtDateIn.Text),
SellTicketId = Guid.NewGuid(),
Products = _products,
ClientId = new Guid(this.ClientId.Text),
UserId = new Guid(this.UserId.Text)
};
bool hasBeenInserted = BusinessSell.InsertTicket(sellTicket);
if (hasBeenInserted)
{
CleanFieldsInserted();
MessageBox.Show("Venta insertada correctamente");
this.dtBuyTickets.DataSource = BusinessSell.GetAllSellTickets().ToList();
}
else
{
MessageBox.Show("Error al insertar venta");
}
}
}
public void Create(SellTicket sellTicket)
{
if (!Check(sellTicket.NameExcursion, sellTicket.SellTime))
{
db.SellTickets.Add(sellTicket);
}
}
private void BtnSellTicket_Click(object sender, EventArgs e)
{
SellTicket sellTicket = new SellTicket(this.employee);
sellTicket.Visible = true;
this.Visible = false;
}
public void Delete(SellTicket sellTicket)
{
if (Check(sellTicket.NameExcursion, sellTicket.SellTime))
{
db.SellTickets.Remove(
db.SellTickets.FirstOrDefault(
x => (x.NameExcursion == sellTicket.NameExcursion) &&
(x.SellTime == sellTicket.SellTime)));
}
}
private void SellDeleteClick(object sender, EventArgs e)
{
SellTicket sellTicket = new SellTicket();
sellTicket.NameExcursion = _sellForm.NameExcrusion;
sellTicket.PriceTicket = _sellForm.PriceTicket;
sellTicket.SellTime = _sellForm.SellTime;
sellTicket.TimeStart = _sellForm.TimeStart;
sellTicket.TypeTicket = _sellForm.TypeTicket;
unitOfWork.RepositorySellTicket.Delete(sellTicket);
_sellForm.AllSalles = unitOfWork.RepositorySellTicket.SummSellTicket(_sellForm.SelectDate);
}
// Método privado para confirmar una inserción
private static bool HasBeenInserted(Guid sellTicketInserted)
{
using (Model _context = new Model())
{
SellTicket sellTicket = _context.SellTickets.Find(sellTicketInserted);
if (sellTicket != null)
{
return(true);
}
return(false);
}
}
public void Update(SellTicket sellTicket)
{
if (Check(sellTicket.NameExcursion, sellTicket.SellTime))
{
BindingList <SellTicket> SellTickets = GetAll();
foreach (SellTicket item in SellTickets)
{
if ((sellTicket.NameExcursion == item.NameExcursion) &&
(sellTicket.SellTime == item.SellTime))
{
item.NameExcursion = sellTicket.NameExcursion;
item.PriceTicket = sellTicket.PriceTicket;
item.SellTime = sellTicket.SellTime;
item.TimeStart = sellTicket.TimeStart;
item.TypeTicket = sellTicket.TypeTicket;
}
}
}
}
private void SellTicketClick(object sender, EventArgs e)
{
SellTicket sellTicket = new SellTicket();
ScheduleExcursionItem scheduleExcursionItem = new ScheduleExcursionItem();
sellTicket.NameExcursion = _mainView.SelectMainTableTypeExcursion;
sellTicket.PriceTicket = _mainView.PriceTickets;
sellTicket.SellTime = DateTime.Now;
sellTicket.TimeStart = _mainView.SelectMainTableTimeStart;
sellTicket.TypeTicket = _mainView.TypeTicket;
unitOfWork.RepositorySellTicket.Create(sellTicket);
scheduleExcursionItem.TicketsLeft = _mainView.SelectMainTableTicketLeft - 1;
scheduleExcursionItem.InitialCost = _mainView.SelectMainTableInitialCost;
scheduleExcursionItem.TimeFinish = _mainView.SelectMainTableTimeFinish;
scheduleExcursionItem.TimeStart = _mainView.SelectMainTableTimeStart;
scheduleExcursionItem.TypeExcursion = _mainView.SelectMainTableTypeExcursion;
scheduleExcursionItem.Venue = _mainView.SelectMainTableVenue;
unitOfWork.RepositoryScheduleExcursionItem.Update(scheduleExcursionItem);
//MessageBox.Show("Билет продан на '" + sellTicket.NameExcursion + "' " + sellTicket.TypeTicket + " по цене "+ sellTicket.PriceTicket.ToString());
}
// Método para eliminar una venta
public static bool DeleteSellTicket(Guid id)
{
try
{
using (Model _context = new Model())
{
SellTicket sellTicket = _context.SellTickets.Find(id);
if (sellTicket != null)
{
foreach (var item in sellTicket.Products)
{
Stock stock = _context.Stocks.Where(x => x.ProductId.Equals(item.ProductId)).FirstOrDefault();
stock.DateOut = null;
stock.SellTicketId = null;
Product product = _context.Products.Find(item.ProductId);
if (product != null)
{
product.Quantity++;
}
}
_context.SellTickets.Attach(sellTicket);
_context.SellTickets.Remove(sellTicket);
_context.SaveChanges();
return(true);
}
return(false);
}
}
catch (Exception ex)
{
return(false);
throw ex;
}
}
// Método para registrar una nueva venta
public static bool InsertTicket(SellTicket sellTicket)
{
try
{
using (Model _context = new Model())
{
IEnumerable <Cashier> cashiers = _context.Cashiers.Where(x => x.Close == false).ToList();
Cashier currentCashier = cashiers.FirstOrDefault();
if (!cashiers.Any())
{
return(false);
}
var virtualTicket = new SellTicket
{
UserId = sellTicket.UserId,
ClientId = sellTicket.ClientId,
Amount = sellTicket.Amount,
Price = sellTicket.Price,
SellTicketDate = sellTicket.SellTicketDate,
SellTicketId = sellTicket.SellTicketId,
CashierId = currentCashier?.CashierId
};
if (currentCashier != null && !currentCashier.Close)
{
_context.SellTickets.Add(virtualTicket);
currentCashier.Amount = currentCashier.Amount + Convert.ToDouble(sellTicket.Price);
currentCashier.ToBank = currentCashier.Amount - 100;
_context.SaveChanges();
}
foreach (var item in sellTicket.Products)
{
Stock stock = _context.Stocks.Where(x => x.ProductId.Equals(item.ProductId)).FirstOrDefault();
stock.SellTicketId = sellTicket.SellTicketId;
stock.DateOut = DateTime.Now;
Product product = _context.Products.Find(item.ProductId);
if (product != null)
{
product.Quantity--;
}
_context.SaveChanges();
}
}
if (HasBeenInserted(sellTicket.SellTicketId))
{
return(true);
}
return(false);
}
catch (DbEntityValidationException e)
{
return(false);
throw new DbEntityValidationException(e.ToString());
}
catch (Exception e)
{
return(false);
throw new Exception(e.ToString());
}
}
