private void CerrarCaja_Load(object sender, EventArgs e)
{
Models.Tickets ticket = new Models.Tickets();
using (ticket)
{
List <Models.Tickets> lista = ticket.getbyUser(Convert.ToInt16(Inicial.id_usario));
double total = 0;
Models.Cortes cortes = new Models.Cortes();
using (cortes)
{
List <Models.Cortes> ultimo = cortes.getnoclose(Convert.ToInt16(Inicial.id_usario));
foreach (Models.Cortes item in ultimo)
{
total += item.Caja_inicial;
}
foreach (Models.Tickets item in lista)
{
total += item.Total;
}
lbEsperado.Text = string.Format("{0:#,0.00}", total);
txtReal.TextAlign = HorizontalAlignment.Right;
txtReal.Text = "0.00";
calcula();
}
}
}
private void button1_Click(object sender, EventArgs e)
{
Models.Tickets tickets = new Models.Tickets();
using (tickets)
{
tickets.A_facturar = Convert.ToInt16(false);
tickets.termina();
}
carga();
dtDetallado.Rows.Clear();
lbDatosCliente.Text = "";
}
private void btnCobrar_Click(object sender, EventArgs e)
{
Models.Tickets tickets = new Models.Tickets();
Folio = folio();
using (tickets)
{
if (Recuperada == false)
{
tickets.Folio = Folio;
tickets.Id_cliente = Id_cliente;
tickets.Subtotal = Caja.Subtotal;
tickets.Descuento = Caja.Descuento;
tickets.Iva = Caja.Iva;
tickets.Total = Caja.Total;
tickets.Status = "A";
tickets.C_iva = Caja.Civa;
tickets.S_iva = Caja.Siva;
tickets.Id_usuario = Convert.ToInt16(Inicial.id_usario);
tickets.Atienda = Convert.ToInt32(Caja.Atiende);
tickets.A_facturar = Convert.ToInt16(chkFactura.Checked);
tickets.Recibido = Convert.ToDouble(txtRecibido.Text);
tickets.CreateTicket();
Caja.Folio_guardado = Folio;
Caja.Facturar = chkFactura.Checked;
Forms.Caja.cancelado = false;
this.Close();
}
else
{
tickets.Folio = Caja.Folio_guardado;
tickets.Id_cliente = Id_cliente;
tickets.Subtotal = Caja.Subtotal;
tickets.Descuento = Caja.Descuento;
tickets.Iva = Caja.Iva;
tickets.Total = Caja.Total;
tickets.Status = "A";
tickets.C_iva = Caja.Civa;
tickets.S_iva = Caja.Siva;
tickets.Id_usuario = Convert.ToInt16(Inicial.id_usario);
tickets.Atienda = Convert.ToInt32(Caja.Atiende);
tickets.A_facturar = Convert.ToInt16(chkFactura.Checked);
tickets.Recibido = Convert.ToDouble(txtRecibido.Text);
tickets.update_ticketbyfolio();
Forms.Caja.cancelado = false;
this.Close();
}
}
}
private void txtIdCliente_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
Models.Client clientes = new Models.Client();
using (clientes)
{
List <Models.Client> client = clientes.getClientbyId(Convert.ToInt16(txtIdCliente.Text));
txtCliente.Text = client[0].Name;
Models.Tickets ticket = new Models.Tickets();
using (ticket)
{
List <Models.Tickets> tic = ticket.getforbuild(txtIdCliente.Text);
dtTickets.Rows.Clear();
foreach (Models.Tickets item in tic)
{
dtTickets.Rows.Add(item.Id, item.Folio, item.Fecha, item.Total);
}
}
}
}
}
private void carga()
{
dtTickets.Rows.Clear();
Models.Tickets tickets = new Models.Tickets();
using (tickets)
{
List <Models.Tickets> ticket = tickets.getTickets_porfacturar();
Models.Client clientes = new Models.Client();
if (ticket.Count > 0)
{
foreach (Models.Tickets item in ticket)
{
using (clientes)
{
List <Models.Client> cliente = clientes.getClientbyId(item.Id_cliente);
dtTickets.Rows.Add(item.Id, item.Fecha, cliente[0].Name, item.Total);
}
}
}
}
}
private void dtTickets_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
int selectedrowindex = dtTickets.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = dtTickets.Rows[selectedrowindex];
int folio = Convert.ToInt16(selectedRow.Cells["folio"].Value);
id_ticket = folio;
Models.Tickets ticket = new Models.Tickets();
using (ticket)
{
List <Models.Tickets> tic = ticket.getTicketsbyId(folio);
Models.Dettickets detallado_ticket = new Models.Dettickets();
using (detallado_ticket)
{
List <Models.Dettickets> detalle = detallado_ticket.getDetalles(folio);
dtDetallado.Rows.Clear();
Models.Product productos = new Models.Product();
foreach (Models.Dettickets item in detalle)
{
using (productos)
{
List <Models.Product> producto = productos.getProductById(item.Id_producto);
dtDetallado.Rows.Add(item.Cantidad, producto[0].Code1, producto[0].Description, item.Pu, item.Total);
}
}
}
Models.Client clientes = new Models.Client();
using (clientes)
{
List <Models.Client> cliente = clientes.getClientbyId(tic[0].Id_cliente);
lbDatosCliente.Text = cliente[0].Name + ", RFC:" + cliente[0].RFC;
}
}
}
private void nueva_tarea()
{
Models.Reports.nuevo_db nuevo = new Models.Reports.nuevo_db();
using (nuevo)
{
//nuevo.ejecuta(" ALTER TABLE `tbafolios` ADD `ticket` INT NOT NULL AFTER `factura`;");
//nuevo.ejecuta("ALTER TABLE `tbatickets` ADD `folio` INT NOT NULL AFTER `id`;");
int ultimo = 0;
Models.Tickets tickets = new Models.Tickets();
using (tickets)
{
List <Models.Tickets> tick = tickets.getTickets();
foreach (Models.Tickets it in tick)
{
nuevo.ejecuta("update tbatickets set folio='" + it.Id + "' where id='" + it.Id + "'");
ultimo = it.Id;
}
}
nuevo.ejecuta("update tbafolios set ticket='" + (ultimo + 1) + "'");
}
System.IO.File.Delete(@"nueva.txt");
}
