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"); }