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