public List <object> GetAll(ref ETransactionResult result) { DaUsuarios _daLista = new DaUsuarios(); List <object> _usuarios = new List <object>(_daLista.Usuarios_GetAll(ref result)); return(_usuarios); }
public ActionResult SaveUsuario(EUsuarios model) { if (!ModelState.IsValid) { return(PartialView("_Nuevo", model)); } try { ETransactionResult result = new ETransactionResult(); _servicioUsurios.Insert(model, ref result); if (result.result != 0) { ModelState.AddModelError("ERROR", result.message); return(PartialView("_Nuevo", model)); } } catch (Exception e) { ModelState.AddModelError("ERROR", e.Message); return(PartialView("_Nuevo", model)); } return(Json("success", JsonRequestBehavior.DenyGet)); }
private void saveProducto(Eproductos item, ref ETransactionResult res) { Daproductos db = new Daproductos(); db.productos_Insert(item, ref res); if (res.result == 0) { EMovimiento mov = new EMovimiento(); EMovimientoDetalle detalle = new EMovimientoDetalle(); ETransactionResult result = new ETransactionResult(); int idDetalle = 0; decimal totalCantidad = 0; mov.fecha = DateTime.Now; mov.idMovimiento = (int)getIdMovimiento(); mov.idTipoMovimiento = "EPT"; mov.usuario = "admin"; totalCantidad = item.cantidad; idDetalle = (int)getIdMovimientoDet(); detalle.idDetalle = idDetalle; detalle.idMovimiento = mov.idMovimiento; detalle.tipoAfectacion = "E"; detalle.idProducto = item.idProducto; detalle.cantidad = totalCantidad; _movimiento.Movimiento_Insert(mov, ref result); if (result.result == 0) { _movimientoDetalle.MovimientoDetalle_Insert(detalle, ref result); } } }
private void btnBackup_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtFile.Text)) { MessageBox.Show("Debe ingresar la carpeta donde se alojara el respaldo.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { LBackup db = new LBackup(); ETransactionResult res = new ETransactionResult(); btnBackup.Enabled = false; btnBuscar.Enabled = false; db.setBackup(txtFile.Text, ref res); if (res.result == 0) { MessageBox.Show("Se ha realizado el respaldo de la base de datos satisfactoriamente.", "Exito", MessageBoxButtons.OK); } else { MessageBox.Show("Se ha generado un error en la generación del respado: " + res.message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } btnBuscar.Enabled = true; txtFile.Text = string.Empty; } }
private void getreporte() { reportViewer1.LocalReport.DataSources.Clear(); List <EReporteVenta> Reporte = new List <EReporteVenta>(); DateTime fini = Convert.ToDateTime(dtpInicio.Value.ToString("dd/MM/yyyy")); DateTime ffin = Convert.ToDateTime(dtpFin.Value.ToString("dd/MM/yyyy")); string fecini = "'" + dtpInicio.Value.ToString("yyyyMMdd") + "'"; string fecfin = "'" + dtpFin.Value.ToString("yyyyMMdd") + "'"; ETransactionResult result = null; Reporte = _servicioReportes.getReporteVenta(fecini, fecfin, chkCancelaciones.Checked, ref result); List <ReportParameter> parametros = new List <ReportParameter>(); ReportDataSource dt = new ReportDataSource(); parametros.Add(new ReportParameter("FechaIni", fini.ToString())); parametros.Add(new ReportParameter("FechaFin", ffin.ToString())); parametros.Add(new ReportParameter("Tipo_Reporte", chkCancelaciones.Checked ? "Reporte de Devoluciones": "Reporte de Ventas")); reportViewer1.Refresh(); reportViewer1.LocalReport.SetParameters(parametros); dt = new ReportDataSource("ReporteVenta", Reporte); reportViewer1.LocalReport.DataSources.Add(dt); reportViewer1.RefreshReport(); }
private void btnAceptar_Click(object sender, EventArgs e) { var lista = getLista(); ETransactionResult result = new ETransactionResult(); string msg = string.Empty; foreach (Eproductos item in lista) { _productos.Update(item, ref result); if (result.result != 0) { msg += "\n Error al actualizar el producto: " + item.descripcion + " - " + result.message; Log.Error(msg); } } if (!string.IsNullOrEmpty(msg)) { foreach (Eproductos item in lista) { _productos.Delete(item, ref result); } MessageBox.Show(msg, "Error al guardar productos", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { lista.ForEach(x => setMovimiento(x)); MessageBox.Show("Se actualizarón los datos correctamente.", "Guardado", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } }
public List <object> GetAll(ref ETransactionResult result) { DaUsuariosRoles _daUsuarioRol = new DaUsuariosRoles(); List <object> _usuarioRol = new List <object>(_daUsuarioRol.UsuariosRoles_GetAll(ref result)); return(_usuarioRol); }
public void Backup(string directorio, ref ETransactionResult _transResult) { _transResult = new ETransactionResult(); try { using (SqlConnection sqlCon = new SqlConnection(conn)) { sqlCon.Open(); using (SqlCommand sqlCmd = new SqlCommand()) { string database = sqlCon.Database; string sql = "BACKUP DATABASE [" + database + "] TO DISK='" + directorio + "\\" + "DB_TPV_" + DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss") + ".bak'"; sqlCmd.Connection = sqlCon; sqlCmd.CommandType = CommandType.Text; sqlCmd.CommandText = sql; sqlCmd.ExecuteNonQuery(); _transResult.message = "OK"; _transResult.result = 0; } } } catch (Exception ex) { _transResult.message = ex.Message; _transResult.result = 1; } }
public List <object> GetAll(ref ETransactionResult result) { DaRoles _daRoles = new DaRoles(); List <object> _roles = new List <object>(_daRoles.Roles_GetAll(ref result)); return(_roles); }
public EImpresion ticket_GetVenta(int ticket_id, ref ETransactionResult _transResult) { EImpresion ticket = new EImpresion(); _transResult = new ETransactionResult(); try { DataSet ds = new DataSet(); using (SqlConnection sqlCon = new SqlConnection(conn)) { sqlCon.Open(); using (SqlCommand sqlCmd = new SqlCommand()) { sqlCmd.Connection = sqlCon; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandText = "D_PR_TicketById"; sqlCmd.Parameters.AddWithValue("@idTicket", ticket_id); SqlDataAdapter da = new SqlDataAdapter(sqlCmd); da.Fill(ds); foreach (DataRow dr in ds.Tables[0].Rows) { ticket.idTicket = (int)dr["idTicket"]; ticket.usuario = (string)dr["usuario"]; ticket.fecha = (DateTime)dr["fecha"]; } ticket.detalle = new List <EImpresionDetalle>(); foreach (DataRow dr in ds.Tables[1].Rows) { EImpresionDetalle item = new EImpresionDetalle(); item.idProducto = (int)dr["idProducto"]; item.codigoBarras = (string)dr["codigoBarras"]; item.descripcion = (string)dr["descripcion"]; item.cantidad = (decimal)dr["cantidad"]; item.precio = (decimal)dr["precio"]; item.total = (decimal)dr["total"]; ticket.detalle.Add(item); } da.Dispose(); _transResult.message = "OK"; _transResult.result = 0; } } } catch (Exception ex) { _transResult.message = ex.Message; _transResult.result = 1; } return(ticket); }
private void FrmCargaMasiva_Load(object sender, EventArgs e) { ETransactionResult result = new ETransactionResult(); var prod = _productos.GetAll(ref result).Cast <Eproductos>().ToList(); var unidad = _Unidad.GetAll(ref result).Cast <EunidadMedida>().ToList(); int maxId = 0; if (prod.Count != 0) { maxId = prod.Select(x => x.idProducto).Max(); } codigoProducto = maxId + 1; var items = new List <Eproductos>() { new Eproductos { idProducto = codigoProducto } }; this.idUnidadDataGridViewTextBoxColumn.DataSource = unidad; //dataGridView1.DataSource = items; }
private void btnCargar_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtFile.Text)) { MessageBox.Show("Debe ingresar la ruta del archivo CSV.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { LCargaMasiva db = new LCargaMasiva(); ETransactionResult res = new ETransactionResult(); btnCargar.Enabled = false; btnBuscar.Enabled = false; db.SetProductos(txtFile.Text, ref res); if (res.result == 0) { MessageBox.Show("Se ha realizado la carga masiva exitosamente.", "Exito", MessageBoxButtons.OK); } else { MessageBox.Show("Se ha generado un error en la carga masiva: " + res.message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } btnBuscar.Enabled = true; txtFile.Text = string.Empty; } }
public ActionResult getLista() { ETransactionResult result = new ETransactionResult(); List <EUsuarios> _usuarios = _servicioUsurios.GetAll(ref result).Cast <EUsuarios>().ToList(); return(Json(_usuarios, JsonRequestBehavior.AllowGet)); }
public void validaUsuario(Usuario user, ref ETransactionResult result) { DA_Usuario db = new DA_Usuario(); var item = db.usuarios_Get(user, ref result); if (result.result != 0) { result.message = "Usurario o Contraseña incorrecta."; } else { if (user.passwd.Trim() != item.passwd.Trim()) { result.message = "Usurario o Contraseña incorrecta."; result.result = 1; } else if (!(bool)item.estatus) { result.message = "Usurario Inactivo."; result.result = 1; } else if (item.roll != "ADMIN") { result.message = "Su Usuario no tiene privilegios para esta aplicación."; result.result = 1; } } }
public EMovimiento Movimiento_Insert(EMovimiento item, ref ETransactionResult _transResult) { EMovimiento itemInserted = null; _transResult = new ETransactionResult(); SqlTransaction transaction = null; try { using (SqlConnection sqlCon = new SqlConnection(conn)) { sqlCon.Open(); using (SqlCommand sqlCmd = new SqlCommand()) { transaction = sqlCon.BeginTransaction("InsertTransaction"); sqlCmd.Transaction = transaction; sqlCmd.Connection = sqlCon; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandText = "D_PR_Movimiento_Insert"; sqlCmd.Parameters.AddWithValue("@idMovimiento", item.idMovimiento); sqlCmd.Parameters.AddWithValue("@fecha", item.fecha); sqlCmd.Parameters.AddWithValue("@usuario", item.usuario); sqlCmd.Parameters.AddWithValue("@idTipoMovimiento", item.idTipoMovimiento); sqlCmd.Parameters.AddWithValue("@observacion", item.observacion); using (var reader = sqlCmd.ExecuteReader()) { while (reader.Read()) { itemInserted = new EMovimiento(); itemInserted.idMovimiento = (int)reader["idMovimiento"]; itemInserted.fecha = (DateTime)reader["fecha"]; itemInserted.usuario = (string)reader["usuario"]; itemInserted.idTipoMovimiento = (string)reader["idTipoMovimiento"]; item.observacion = (reader["observacion"] == DBNull.Value) ? "" : (string)reader["observacion"]; } } transaction.Commit(); _transResult.message = "OK"; _transResult.result = 0; } } } catch (Exception ex) { _transResult.message = ex.Message; _transResult.result = 1; try { transaction.Rollback(); } catch (Exception rollBackEx) { _transResult.rollbackMessage = rollBackEx.Message; _transResult.result = 1; } } return(itemInserted); }
public List <EExistencias> Existencia_get(ref ETransactionResult _transResult) { List <EExistencias> lista = new List <EExistencias>(); _transResult = new ETransactionResult(); SqlTransaction transaction = null; try { using (SqlConnection sqlCon = new SqlConnection(conn)) { sqlCon.Open(); using (SqlCommand sqlCmd = new SqlCommand()) { string strSql = ""; strSql = "SELECT * FROM Existencias "; transaction = sqlCon.BeginTransaction("SelectTransaction"); sqlCmd.Transaction = transaction; sqlCmd.Connection = sqlCon; sqlCmd.CommandType = CommandType.Text; sqlCmd.CommandText = strSql; using (var reader = sqlCmd.ExecuteReader()) while (reader.Read()) { EExistencias itemFinded = new EExistencias(); itemFinded.Unidad = (string)reader["Unidad"]; itemFinded.Existencia = (decimal)reader["Existencia"]; itemFinded.Inversion = (decimal)reader["Inversion"]; itemFinded.Venta = (decimal)reader["Venta"]; itemFinded.Ganancia = (decimal)reader["Ganancia"]; lista.Add(itemFinded); } transaction.Commit(); _transResult.message = "OK"; _transResult.result = 0; } } } catch (Exception ex) { _transResult.message = ex.Message; _transResult.result = 1; try { transaction.Rollback(); } catch (Exception rollBackEx) { _transResult.rollbackMessage = rollBackEx.Message; _transResult.result = 1; } } return(lista); }
public EColonias Colonias_Update(EColonias item, ref ETransactionResult _transResult) { EColonias itemUpdated = null; _transResult = new ETransactionResult(); SqlTransaction transaction = null; try { using (SqlConnection sqlCon = new SqlConnection(conn)) { sqlCon.Open(); using (SqlCommand sqlCmd = new SqlCommand()) { transaction = sqlCon.BeginTransaction("UpdateTransaction"); sqlCmd.Transaction = transaction; sqlCmd.Connection = sqlCon; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandText = "SP_Colonias_Update"; sqlCmd.Parameters.AddWithValue("@Id", item.Id); sqlCmd.Parameters.AddWithValue("@IdEstado", item.IdEstado); sqlCmd.Parameters.AddWithValue("@IdMunicipio", item.IdMunicipio); sqlCmd.Parameters.AddWithValue("@cp", item.cp); sqlCmd.Parameters.AddWithValue("@Descripcion", item.Descripcion); using (var reader = sqlCmd.ExecuteReader()) { while (reader.Read()) { itemUpdated = new EColonias(); itemUpdated.Id = (int)reader["Id"]; itemUpdated.IdEstado = (int)reader["IdEstado"]; itemUpdated.IdMunicipio = (int)reader["IdMunicipio"]; itemUpdated.cp = (long)reader["cp"]; itemUpdated.Descripcion = reader["Descripcion"] == DBNull.Value ? null : (string)reader["Descripcion"]; } } transaction.Commit(); _transResult.message = "OK"; _transResult.result = 1; } } } catch (Exception ex) { _transResult.message = ex.Message; _transResult.result = 1; try { transaction.Rollback(); } catch (Exception rollBackEx) { _transResult.rollbackMessage = rollBackEx.Message; _transResult.result = 1; } } return(itemUpdated); }
public EMovimientoDetalle MovimientoDetalle_Update(EMovimientoDetalle item, ref ETransactionResult _transResult) { EMovimientoDetalle itemUpdated = null; _transResult = new ETransactionResult(); SqlTransaction transaction = null; try { using (SqlConnection sqlCon = new SqlConnection(conn)) { sqlCon.Open(); using (SqlCommand sqlCmd = new SqlCommand()) { transaction = sqlCon.BeginTransaction("UpdateTransaction"); sqlCmd.Transaction = transaction; sqlCmd.Connection = sqlCon; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandText = "D_PR_MovimientoDetalle_Update"; sqlCmd.Parameters.AddWithValue("@idDetalle", item.idDetalle); sqlCmd.Parameters.AddWithValue("@idMovimiento", item.idMovimiento); sqlCmd.Parameters.AddWithValue("@idProducto", item.idProducto); sqlCmd.Parameters.AddWithValue("@cantidad", item.cantidad); sqlCmd.Parameters.AddWithValue("@tipoAfectacion", item.tipoAfectacion); using (var reader = sqlCmd.ExecuteReader()) { while (reader.Read()) { itemUpdated = new EMovimientoDetalle(); itemUpdated.idDetalle = (int)reader["idDetalle"]; itemUpdated.idMovimiento = (int)reader["idMovimiento"]; itemUpdated.idProducto = (int)reader["idProducto"]; itemUpdated.cantidad = (decimal)reader["cantidad"]; itemUpdated.tipoAfectacion = (string)reader["tipoAfectacion"]; } } transaction.Commit(); _transResult.message = "OK"; _transResult.result = 0; } } } catch (Exception ex) { _transResult.message = ex.Message; _transResult.result = 1; try { transaction.Rollback(); } catch (Exception rollBackEx) { _transResult.rollbackMessage = rollBackEx.Message; _transResult.result = 1; } } return(itemUpdated); }
public EUsuarios Usuarios_Get(EUsuarios item, ref ETransactionResult _transResult) { EUsuarios itemFinded = null; _transResult = new ETransactionResult(); SqlTransaction transaction = null; try { using (SqlConnection sqlCon = new SqlConnection(conn)) { sqlCon.Open(); using (SqlCommand sqlCmd = new SqlCommand()) { transaction = sqlCon.BeginTransaction("SelectTransaction"); sqlCmd.Transaction = transaction; sqlCmd.Connection = sqlCon; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.AddWithValue("@Id", item.Id); sqlCmd.Parameters.AddWithValue("@Loggin", item.Loggin); sqlCmd.CommandText = "SP_Usuarios_Select"; using (var reader = sqlCmd.ExecuteReader()) while (reader.Read()) { itemFinded = new EUsuarios(); itemFinded.Id = (int)reader["Id"]; itemFinded.Nombre = (string)reader["Nombre"]; itemFinded.ApellidoP = (string)reader["ApellidoP"]; itemFinded.ApellidoM = (string)reader["ApellidoM"]; itemFinded.Telefono = reader["Telefono"] == DBNull.Value ? null : (decimal?)reader["Telefono"]; itemFinded.Direccion = reader["Direccion"] == DBNull.Value ? null : (string)reader["Direccion"]; itemFinded.Email = reader["Email"] == DBNull.Value ? null : (string)reader["Email"]; itemFinded.Loggin = reader["Loggin"] == DBNull.Value ? null : (string)reader["Loggin"]; itemFinded.Password = reader["Password"] == DBNull.Value ? null : (string)reader["Password"]; itemFinded.Estado = (bool)reader["Estado"]; } transaction.Commit(); _transResult.message = "OK"; _transResult.result = 0; } } } catch (Exception ex) { _transResult.message = ex.Message; _transResult.result = 1; try { transaction.Rollback(); } catch (Exception rollBackEx) { _transResult.rollbackMessage = rollBackEx.Message; _transResult.result = 1; } } return(itemFinded); }
private void llenaCombo() { ETransactionResult result = new ETransactionResult(); List <Eproductos> productos = _productos.GetAll(ref result).Cast <Eproductos>().Where(x => x.idUnidad == 1 && x.estado == true).ToList(); comboBox1.DisplayMember = "Descripcion"; comboBox1.ValueMember = "Id"; comboBox1.DataSource = productos.Select(p => new { Id = p.idProducto, Descripcion = p.descripcion }).OrderBy(x => x.Descripcion).ToList(); }
public List <EdetalleTicket> detalleTicket_GetByIdTicket(Eticket enc, ref ETransactionResult _transResult) { var list = new List <EdetalleTicket>(); _transResult = new ETransactionResult(); SqlTransaction transaction = null; try { using (SqlConnection sqlCon = new SqlConnection(conn)) { sqlCon.Open(); using (SqlCommand sqlCmd = new SqlCommand()) { transaction = sqlCon.BeginTransaction("SelectAllTranstaction"); sqlCmd.Transaction = transaction; sqlCmd.Connection = sqlCon; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandText = "D_PR_detalleTicket_byIdTicket"; sqlCmd.Parameters.AddWithValue("@idTicket", enc.idTicket); using (var reader = sqlCmd.ExecuteReader()) while (reader.Read()) { var item = new EdetalleTicket(); item.idDetalle = (int)reader["idDetalle"]; item.idTicket = (int)reader["idTicket"]; item.fecha = (DateTime)reader["fecha"]; item.idProducto = (int)reader["idProducto"]; item.cantidad = (decimal)reader["cantidad"]; item.precio = (decimal)reader["precio"]; item.total = (decimal)reader["total"]; list.Add(item); } transaction.Commit(); _transResult.message = "OK"; _transResult.result = 0; } } } catch (Exception ex) { _transResult.message = ex.Message; _transResult.result = 1; try { transaction.Rollback(); } catch (Exception rollBackEx) { _transResult.rollbackMessage = rollBackEx.Message; _transResult.result = 1; } } return(list); }
public List <Usuario> usuarios_GetAll(ref ETransactionResult _transResult) { var list = new List <Usuario>(); _transResult = new ETransactionResult(); SqlTransaction transaction = null; try { using (SqlConnection sqlCon = new SqlConnection(conn)) { sqlCon.Open(); using (SqlCommand sqlCmd = new SqlCommand()) { transaction = sqlCon.BeginTransaction("SelectAllTranstaction"); sqlCmd.Transaction = transaction; sqlCmd.Connection = sqlCon; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandText = "D_PR_usuarios_SelectAll"; using (var reader = sqlCmd.ExecuteReader()) while (reader.Read()) { var item = new Usuario(); item.usuario = (string)reader["usuario"]; item.passwd = (string)reader["passwd"]; item.nombre = (string)reader["nombre"]; item.apellidoP = (string)reader["apellidoP"]; item.apellidoM = (string)reader["apellidoM"]; item.roll = (string)reader["roll"]; item.estatus = reader["estatus"] == DBNull.Value ? null : (bool?)reader["estatus"]; list.Add(item); } transaction.Commit(); _transResult.message = "OK"; _transResult.result = 0; } } } catch (Exception ex) { _transResult.message = ex.Message; _transResult.result = 1; try { transaction.Rollback(); } catch (Exception rollBackEx) { _transResult.rollbackMessage = rollBackEx.Message; _transResult.result = 1; } } return(list); }
public Eproductos productos_Get(Eproductos item, ref ETransactionResult _transResult) { Eproductos itemFinded = null; _transResult = new ETransactionResult(); SqlTransaction transaction = null; try { using (SqlConnection sqlCon = new SqlConnection(conn)) { sqlCon.Open(); using (SqlCommand sqlCmd = new SqlCommand()) { transaction = sqlCon.BeginTransaction("SelectTransaction"); sqlCmd.Transaction = transaction; sqlCmd.Connection = sqlCon; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.AddWithValue("@idProducto", item.idProducto); sqlCmd.CommandText = "D_PR_productos_Select"; using (var reader = sqlCmd.ExecuteReader()) while (reader.Read()) { itemFinded = new Eproductos(); itemFinded.idProducto = (int)reader["idProducto"]; itemFinded.idUnidad = reader["idUnidad"] == DBNull.Value ? null : (int?)reader["idUnidad"]; itemFinded.descripcion = (string)reader["descripcion"]; itemFinded.codigoBarras = (string)reader["codigoBarras"]; itemFinded.precio = (decimal)reader["precio"]; itemFinded.precioReal = (decimal)reader["precioReal"]; itemFinded.cantidad = (decimal)reader["cantidad"]; itemFinded.estado = (bool)reader["estado"]; } transaction.Commit(); _transResult.message = "OK"; _transResult.result = 0; } } } catch (Exception ex) { _transResult.message = ex.Message; _transResult.result = 1; try { transaction.Rollback(); } catch (Exception rollBackEx) { _transResult.rollbackMessage = rollBackEx.Message; _transResult.result = 1; } } return(itemFinded); }
public List <Eproductos> productos_GetAll(ref ETransactionResult _transResult) { var list = new List <Eproductos>(); _transResult = new ETransactionResult(); SqlTransaction transaction = null; try { using (SqlConnection sqlCon = new SqlConnection(conn)) { sqlCon.Open(); using (SqlCommand sqlCmd = new SqlCommand()) { transaction = sqlCon.BeginTransaction("SelectAllTranstaction"); sqlCmd.Transaction = transaction; sqlCmd.Connection = sqlCon; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandText = "D_PR_productos_SelectAll"; using (var reader = sqlCmd.ExecuteReader()) while (reader.Read()) { var item = new Eproductos(); item.idProducto = (int)reader["idProducto"]; item.idUnidad = reader["idUnidad"] == DBNull.Value ? null : (int?)reader["idUnidad"]; item.descripcion = (string)reader["descripcion"]; item.codigoBarras = (string)reader["codigoBarras"]; item.precio = (decimal)reader["precio"]; item.precioReal = (decimal)reader["precioReal"]; item.cantidad = (decimal)reader["cantidad"]; item.estado = (bool)reader["estado"]; list.Add(item); } transaction.Commit(); _transResult.message = "OK"; _transResult.result = 0; } } } catch (Exception ex) { _transResult.message = ex.Message; _transResult.result = 1; try { transaction.Rollback(); } catch (Exception rollBackEx) { _transResult.rollbackMessage = rollBackEx.Message; _transResult.result = 1; } } return(list); }
public EEstados Estados_Insert(EEstados item, ref ETransactionResult _transResult) { EEstados itemInserted = null; _transResult = new ETransactionResult(); SqlTransaction transaction = null; try { using (SqlConnection sqlCon = new SqlConnection(conn)) { sqlCon.Open(); using (SqlCommand sqlCmd = new SqlCommand()) { transaction = sqlCon.BeginTransaction("InsertTransaction"); sqlCmd.Transaction = transaction; sqlCmd.Connection = sqlCon; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandText = "SP_Estados_Insert"; sqlCmd.Parameters.AddWithValue("@Id", item.Id); sqlCmd.Parameters.AddWithValue("@IdPais", item.IdPais); sqlCmd.Parameters.AddWithValue("@descripcion", item.descripcion); using (var reader = sqlCmd.ExecuteReader()) { while (reader.Read()) { itemInserted = new EEstados(); itemInserted.Id = (int)reader["Id"]; itemInserted.IdPais = (int)reader["IdPais"]; itemInserted.descripcion = reader["descripcion"] == DBNull.Value ? null : (string)reader["descripcion"]; } } transaction.Commit(); _transResult.message = "OK"; _transResult.result = 0; } } } catch (Exception ex) { _transResult.message = ex.Message; _transResult.result = 1; try { transaction.Rollback(); } catch (Exception rollBackEx) { _transResult.rollbackMessage = rollBackEx.Message; _transResult.result = 1; } } return(itemInserted); }
public List <Eticket> ticket_GetAll(ref ETransactionResult _transResult) { var list = new List <Eticket>(); _transResult = new ETransactionResult(); SqlTransaction transaction = null; try { using (SqlConnection sqlCon = new SqlConnection(conn)) { sqlCon.Open(); using (SqlCommand sqlCmd = new SqlCommand()) { transaction = sqlCon.BeginTransaction("SelectAllTranstaction"); sqlCmd.Transaction = transaction; sqlCmd.Connection = sqlCon; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandText = "D_PR_ticket_SelectAll"; using (var reader = sqlCmd.ExecuteReader()) while (reader.Read()) { var item = new Eticket(); item.idTicket = (int)reader["idTicket"]; item.fecha = (DateTime)reader["fecha"]; item.usuario = (string)reader["usuario"]; item.total = (decimal)reader["total"]; item.cancelado = (bool)reader["cancelado"]; item.observacion = (reader["observacion"] == DBNull.Value) ? "" : (string)reader["observacion"]; list.Add(item); } transaction.Commit(); _transResult.message = "OK"; _transResult.result = 0; } } } catch (Exception ex) { _transResult.message = ex.Message; _transResult.result = 1; try { transaction.Rollback(); } catch (Exception rollBackEx) { _transResult.rollbackMessage = rollBackEx.Message; _transResult.result = 1; } } return(list); }
public Usuario usuarios_Get(Usuario item, ref ETransactionResult _transResult) { Usuario itemFinded = null; _transResult = new ETransactionResult(); SqlTransaction transaction = null; try { using (SqlConnection sqlCon = new SqlConnection(conn)) { sqlCon.Open(); using (SqlCommand sqlCmd = new SqlCommand()) { transaction = sqlCon.BeginTransaction("SelectTransaction"); sqlCmd.Transaction = transaction; sqlCmd.Connection = sqlCon; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.AddWithValue("@usuario", item.usuario); sqlCmd.CommandText = "D_PR_usuarios_Select"; using (var reader = sqlCmd.ExecuteReader()) while (reader.Read()) { itemFinded = new Usuario(); itemFinded.usuario = (string)reader["usuario"]; itemFinded.passwd = (string)reader["passwd"]; itemFinded.nombre = (string)reader["nombre"]; itemFinded.apellidoP = (string)reader["apellidoP"]; itemFinded.apellidoM = (string)reader["apellidoM"]; itemFinded.roll = (string)reader["roll"]; itemFinded.estatus = reader["estatus"] == DBNull.Value ? null : (bool?)reader["estatus"]; } transaction.Commit(); _transResult.message = "OK"; _transResult.result = 0; } } } catch (Exception ex) { _transResult.message = ex.Message; _transResult.result = 1; try { transaction.Rollback(); } catch (Exception rollBackEx) { _transResult.rollbackMessage = rollBackEx.Message; _transResult.result = 1; } } return(itemFinded); }
private void EdicionMasiva_Load(object sender, EventArgs e) { List <Eproductos> items = new List <Eproductos>(); ETransactionResult _result = new ETransactionResult(); items = _prods.GetAll(ref _result).Cast <Eproductos>().ToList(); dataGridView1.DataSource = items; dataGridView1.Columns[0].ReadOnly = true; dataGridView1.Columns[1].ReadOnly = true; }
public Eticket ticket_Get(Eticket item, ref ETransactionResult _transResult) { Eticket itemFinded = null; _transResult = new ETransactionResult(); SqlTransaction transaction = null; try { using (SqlConnection sqlCon = new SqlConnection(conn)) { sqlCon.Open(); using (SqlCommand sqlCmd = new SqlCommand()) { transaction = sqlCon.BeginTransaction("SelectTransaction"); sqlCmd.Transaction = transaction; sqlCmd.Connection = sqlCon; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.AddWithValue("@idTicket", item.idTicket); sqlCmd.CommandText = "D_PR_ticket_Select"; using (var reader = sqlCmd.ExecuteReader()) while (reader.Read()) { itemFinded = new Eticket(); itemFinded.idTicket = (int)reader["idTicket"]; itemFinded.fecha = (DateTime)reader["fecha"]; itemFinded.usuario = (string)reader["usuario"]; itemFinded.total = (decimal)reader["total"]; itemFinded.cancelado = (bool)reader["cancelado"]; itemFinded.observacion = (reader["observacion"] == DBNull.Value) ? "" : (string)reader["observacion"]; } transaction.Commit(); _transResult.message = "OK"; _transResult.result = 0; } } } catch (Exception ex) { _transResult.message = ex.Message; _transResult.result = 1; try { transaction.Rollback(); } catch (Exception rollBackEx) { _transResult.rollbackMessage = rollBackEx.Message; _transResult.result = 1; } } return(itemFinded); }
public Usuario getUsuraio(Usuario user, ref ETransactionResult result) { DA_Usuario db = new DA_Usuario(); var item = db.usuarios_Get(user, ref result); if (result.result != 0) { result.message = "El Usuario no Existe."; } return(item); }