3.3 Implementation of TCP Vegas
3.3.2 Algorithm
Manual de Programación
Podremos revisar en nuestro trabajo que está desarrollado con la técnica de programación orientada a objetos, para eso hemos creado una para cada tipo de movimiento, es decir, tenemos clases como: Bodega, Consulta Filtrada, MovimientoC, producto, etc.
A continuación revisaremos las mismas donde detallamos el código fuente:
CLASE BODEGA.- using System; using System.Linq; using System.Collections.Generic; using System.Text; using System.Data.SqlServerCe; using System.Data; namespace Tesis_ES_Movil.Bodegas { classBodega {
publicstaticTesisBD_ESDataSet.BodegaDataTable llenarBodega() {
TesisBD_ESDataSet.BodegaDataTable dat = newTesisBD_ESDataSet.BodegaDataTable();
System.Data.SqlServerCe.SqlCeConnection conn = new System.Data.SqlServerCe.SqlCeConnection(
("Data Source=" +
(System.IO.Path.Combine(System.IO.Path.GetDirectoryName(System.Reflectio n.Assembly.GetExecutingAssembly().GetName().CodeBase),
{
conn.Open();
string sql = @"select * FROM Bodega";
System.Data.SqlServerCe.SqlCeCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
SqlCeDataAdapter da = newSqlCeDataAdapter(cmd); da.Fill(dat);
conn.Close(); }
return dat; }
publicstaticstring Insertar(string Descripcion) {
TesisBD_ESDataSet.BodegaDataTable dat = newTesisBD_ESDataSet.BodegaDataTable();
System.Data.SqlServerCe.SqlCeConnection conn = new System.Data.SqlServerCe.SqlCeConnection(
("Data Source=" +
(System.IO.Path.Combine(System.IO.Path.GetDirectoryName(System.Reflectio n.Assembly.GetExecutingAssembly().GetName().CodeBase),
"TesisBD_ES.sdf") + ";Max Database Size=2047"))); {
string sql = @"Insert into Bodega(Descripcion)values('" + Descripcion + "')"; conn.Open();
System.Data.SqlServerCe.SqlCeCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
SqlCeDataAdapter da = newSqlCeDataAdapter(cmd); da.Fill(dat);
conn.Close(); }
return"OK"; }
publicstaticstring Modificar(int Codigo, string Descripcion) {
TesisBD_ESDataSet.BodegaDataTable dat = newTesisBD_ESDataSet.BodegaDataTable();
System.Data.SqlServerCe.SqlCeConnection conn = new System.Data.SqlServerCe.SqlCeConnection(
("Data Source=" +
(System.IO.Path.Combine(System.IO.Path.GetDirectoryName(System.Reflectio n.Assembly.GetExecutingAssembly().GetName().CodeBase),
"TesisBD_ES.sdf") + ";Max Database Size=2047"))); {
string sql = @"Update Bodega Set Descripcion ='" + Descripcion + "' Where Codigo=" + Codigo; conn.Open(); System.Data.SqlServerCe.SqlCeCommand cmd = conn.CreateCommand(); cmd.CommandText = sql; cmd.ExecuteNonQuery(); conn.Close(); } return"OK"; }
publicstaticstring Eliminar(int Codigo) {
TesisBD_ESDataSet.BodegaDataTable dat = newTesisBD_ESDataSet.BodegaDataTable();
System.Data.SqlServerCe.SqlCeConnection conn = new System.Data.SqlServerCe.SqlCeConnection(
("Data Source=" +
(System.IO.Path.Combine(System.IO.Path.GetDirectoryName(System.Reflectio n.Assembly.GetExecutingAssembly().GetName().CodeBase),
"TesisBD_ES.sdf") + ";Max Database Size=2047"))); {
string sql = @"Delete from Bodega Where Codigo=" + Codigo; conn.Open(); System.Data.SqlServerCe.SqlCeCommand cmd = conn.CreateCommand(); cmd.CommandText = sql; cmd.ExecuteNonQuery(); conn.Close(); } return"OK"; }
publicstaticstring ObtieneBodega(int Codigo) {
string Descripcion;
System.Data.SqlServerCe.SqlCeConnection cn = new System.Data.SqlServerCe.SqlCeConnection(
("Data Source=" +
(System.IO.Path.Combine(System.IO.Path.GetDirectoryName(System.Reflectio n.Assembly.GetExecutingAssembly().GetName().CodeBase),
"TesisBD_ES.sdf") + ";Max Database Size=2047")));
TesisBD_ESDataSet.BodegaDataTable dat = newTesisBD_ESDataSet.BodegaDataTable();
SqlCeCommand cmd = newSqlCeCommand(); cmd.Connection = cn;
string sql = @"Select * from Bodega where Codigo = " + Codigo; cmd.CommandText = sql;
SqlCeDataAdapter da = newSqlCeDataAdapter(cmd); da.Fill(dat);
cn.Open();
SqlCeDataReader reader = cmd.ExecuteReader(); do { reader.Read(); Descripcion = reader.GetString(1).Trim(); } while (reader.NextResult()); reader.Close(); cn.Close(); return Descripcion; } } } Clase MOVIMIENTOC using System; using System.Linq; using System.Collections.Generic; using System.Text; using System.Data.SqlServerCe; using System.Data; namespace Tesis_ES_Movil { classMovimientoC { publicstring Tipo; publicDateTime Fecha; publicint UsuCod; publicint Bodcod;
publicstring Observacion; publicint PrvCod;
publicstaticTesisBD_ESDataSet.MoviCDataTable llenarMoviC() {
TesisBD_ESDataSet.MoviCDataTable dat = newTesisBD_ESDataSet.MoviCDataTable();
System.Data.SqlServerCe.SqlCeConnection conn = new System.Data.SqlServerCe.SqlCeConnection(
("Data Source=" +
(System.IO.Path.Combine(System.IO.Path.GetDirectoryName(System.Reflectio n.Assembly.GetExecutingAssembly().GetName().CodeBase),
"TesisBD_ES.sdf") + ";Max Database Size=2047"))); {
conn.Open();
string sql = @"select * FROM MoviC";
System.Data.SqlServerCe.SqlCeCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
SqlCeDataAdapter da = newSqlCeDataAdapter(cmd); da.Fill(dat);
conn.Close(); }
return dat; }
publicstaticstring Insertar(string Tipo, DateTime Fecha, int UsuCod, int BodCod, string Observacion, int Estado, int Proveedor)
{
TesisBD_ESDataSet.ProductoDataTable dat = newTesisBD_ESDataSet.ProductoDataTable();
System.Data.SqlServerCe.SqlCeConnection conn = new System.Data.SqlServerCe.SqlCeConnection(
("Data Source=" +
(System.IO.Path.Combine(System.IO.Path.GetDirectoryName(System.Reflectio n.Assembly.GetExecutingAssembly().GetName().CodeBase),
"TesisBD_ES.sdf") + ";Max Database Size=2047"))); {
string LaFecha;
LaFecha = Fecha.ToString("MM/dd/yyyy hh:mm");
string sql = @"Insert into MoviC(Tipo, Fecha, UsuCod, BodCod, Observacion, Estado, PrvCod)values('" + Tipo + "','" + LaFecha + "', " + UsuCod + ", " + BodCod + ", '" + Observacion + "', 1, " + Proveedor + ")";
conn.Open();
System.Data.SqlServerCe.SqlCeCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
SqlCeDataAdapter da = newSqlCeDataAdapter(cmd); da.Fill(dat);
conn.Close(); }
return"OK"; }
publicstaticstring Insertar(string Tipo, DateTime Fecha, int UsuCod, int BodCod, string Observacion, int Estado)
TesisBD_ESDataSet.ProductoDataTable dat = newTesisBD_ESDataSet.ProductoDataTable();
System.Data.SqlServerCe.SqlCeConnection conn = new System.Data.SqlServerCe.SqlCeConnection(
("Data Source=" +
(System.IO.Path.Combine(System.IO.Path.GetDirectoryName(System.Reflectio n.Assembly.GetExecutingAssembly().GetName().CodeBase),
"TesisBD_ES.sdf") + ";Max Database Size=2047"))); {
string LaFecha;
LaFecha = Fecha.ToString("MM/dd/yyyy hh:mm");
string sql = @"Insert into MoviC(Tipo, Fecha, UsuCod, BodCod, Observacion, Estado, PrvCod)values('" + Tipo + "','" + LaFecha + "', " + UsuCod + ", " + BodCod + ", '" + Observacion + "', 1, 0)";
conn.Open();
System.Data.SqlServerCe.SqlCeCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
SqlCeDataAdapter da = newSqlCeDataAdapter(cmd); da.Fill(dat);
conn.Close(); }
return"OK"; }
publicstaticMovimientoC ObtieneMovxNum(int NumMov) {
MovimientoC MC = newMovimientoC();
System.Data.SqlServerCe.SqlCeConnection cn = new System.Data.SqlServerCe.SqlCeConnection(
("Data Source=" +
(System.IO.Path.Combine(System.IO.Path.GetDirectoryName(System.Reflectio n.Assembly.GetExecutingAssembly().GetName().CodeBase),
"TesisBD_ES.sdf") + ";Max Database Size=2047")));
TesisBD_ESDataSet.MoviCDataTable dat = newTesisBD_ESDataSet.MoviCDataTable();
SqlCeCommand cmd = newSqlCeCommand(); cmd.Connection = cn;
string sql = @"Select * from MoviC where Numero = " + NumMov; cmd.CommandText = sql;
SqlCeDataAdapter da = newSqlCeDataAdapter(cmd); da.Fill(dat);
cn.Open();
SqlCeDataReader reader = cmd.ExecuteReader(); do
{
MC.Tipo = reader.GetString(1).Trim(); MC.Fecha = reader.GetDateTime(2); MC.UsuCod = reader.GetInt32(3); MC.Bodcod = reader.GetInt32(4); MC.Observacion = reader.GetString(5); MC.PrvCod = reader.GetInt32(6); } while (reader.NextResult()); reader.Close(); cn.Close(); return MC; } publicstaticint ObtieneUltimo() { int Numero;
System.Data.SqlServerCe.SqlCeConnection cn = new System.Data.SqlServerCe.SqlCeConnection(
("Data Source=" +
(System.IO.Path.Combine(System.IO.Path.GetDirectoryName(System.Reflectio n.Assembly.GetExecutingAssembly().GetName().CodeBase),
"TesisBD_ES.sdf") + ";Max Database Size=2047")));
TesisBD_ESDataSet.MoviCDataTable dat = newTesisBD_ESDataSet.MoviCDataTable();
SqlCeCommand cmd = newSqlCeCommand(); cmd.Connection = cn;
string sql = @"Select * from MoviC order by Numero Desc"; cmd.CommandText = sql;
SqlCeDataAdapter da = newSqlCeDataAdapter(cmd); da.Fill(dat);
cn.Open();
SqlCeDataReader reader = cmd.ExecuteReader(); reader.Read(); Numero = reader.GetInt32(0); return Numero; } } } CLASE CONSULTAFILTRADA using System; using System.Linq;
using System.Collections.Generic; using System.Text; using System.Data.SqlServerCe; namespace Tesis_ES_Movil { classConsultaFiltrada {
publicstaticTesisBD_ESDataSet.MoviCDataTable ConsultaxFechas(DateTime
desde, DateTime hasta, string Consultar) { string tipo; if (Consultar == "Entrada") tipo = "E"; else tipo = "S"; TesisBD_ESDataSet.MoviCDataTable dt = newTesisBD_ESDataSet.MoviCDataTable();
System.Data.SqlServerCe.SqlCeConnection conn = new System.Data.SqlServerCe.SqlCeConnection(
("Data Source=" +
(System.IO.Path.Combine(System.IO.Path.GetDirectoryName(System.Reflectio n.Assembly.GetExecutingAssembly().GetName().CodeBase),
"TesisBD_ES.sdf") + ";Max Database Size=2047"))); {
string sql = @"select * FROM MoviC where fecha >= '"+ desde.ToString("MM/dd/yyyy")+ " 00:00:01' and fecha <= '"+ hasta.ToString("MM/dd/yyyy")+ " 23:59:59' and tipo = @tipo"; System.Data.SqlServerCe.SqlCeCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
cmd.Parameters.AddWithValue("@tipo", tipo);
SqlCeDataAdapter da = newSqlCeDataAdapter(cmd); da.Fill(dt);
} return dt; }
publicstaticTesisBD_ESDataSet.MoviDDataTable ConsultaDetalle(int NumMov) {
TesisBD_ESDataSet.MoviDDataTable dat = newTesisBD_ESDataSet.MoviDDataTable();
System.Data.SqlServerCe.SqlCeConnection conn = new System.Data.SqlServerCe.SqlCeConnection(
("Data Source=" +
n.Assembly.GetExecutingAssembly().GetName().CodeBase), "TesisBD_ES.sdf") + ";Max Database Size=2047")));
{
string sql = @"select MoviD.Secuencia, MoviD.MoDCantidad, MoviD.ProCod, Producto.Descripcion FROM MoviD
inner join Producto
on MoviD.ProCod = Producto.codigo and Numero = @NumMov "; System.Data.SqlServerCe.SqlCeCommand cmd =
conn.CreateCommand();
cmd.CommandText = sql;
cmd.Parameters.AddWithValue("@NumMov", NumMov);
SqlCeDataAdapter da = newSqlCeDataAdapter(cmd); da.Fill(dat);
} return dat; }
publicstaticTesisBD_ESDataSet.MoviDDataTable ConsultaKardex(DateTime
desde, DateTime hasta, int CodPro) {
TesisBD_ESDataSet.MoviDDataTable dt = newTesisBD_ESDataSet.MoviDDataTable();
System.Data.SqlServerCe.SqlCeConnection conn = new System.Data.SqlServerCe.SqlCeConnection(
("Data Source=" +
(System.IO.Path.Combine(System.IO.Path.GetDirectoryName(System.Reflectio n.Assembly.GetExecutingAssembly().GetName().CodeBase),
"TesisBD_ES.sdf") + ";Max Database Size=2047"))); {
string sql = @"select * FROM MoviD
where MoDfecha >= '"+desde.ToString("MM/dd/yyyy")+ " 00:00:01' and MoDfecha <= '"+ hasta.ToString("MM/dd/yyyy")+ " 23:59:59' and ProCod = @CodPro Order By Orden";
System.Data.SqlServerCe.SqlCeCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
cmd.Parameters.AddWithValue("@CodPro", CodPro);
SqlCeDataAdapter da = newSqlCeDataAdapter(cmd); da.Fill(dt);
} return dt; }
} CLASE PRODUCTO using System; using System.Linq; using System.Collections.Generic; using System.Text; using System.Data.SqlServerCe; using System.Data; namespace Tesis_ES_Movil.Productos { classProducto { publicstring Descripcion; publicint Stock;
publicstaticTesisBD_ESDataSet.ProductoDataTable llenarProducto() {
TesisBD_ESDataSet.ProductoDataTable dat = newTesisBD_ESDataSet.ProductoDataTable();
System.Data.SqlServerCe.SqlCeConnection conn = new System.Data.SqlServerCe.SqlCeConnection(
("Data Source=" +
(System.IO.Path.Combine(System.IO.Path.GetDirectoryName(System.Reflectio n.Assembly.GetExecutingAssembly().GetName().CodeBase),
"TesisBD_ES.sdf") + ";Max Database Size=2047"))); {
conn.Open();
string sql = @"select * FROM Producto";
System.Data.SqlServerCe.SqlCeCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
SqlCeDataAdapter da = newSqlCeDataAdapter(cmd); da.Fill(dat);
conn.Close(); }
return dat; }
publicstaticstring Insertar(string Descripcion) {
TesisBD_ESDataSet.ProductoDataTable dat = newTesisBD_ESDataSet.ProductoDataTable();
System.Data.SqlServerCe.SqlCeConnection conn = new System.Data.SqlServerCe.SqlCeConnection(
("Data Source=" +
(System.IO.Path.Combine(System.IO.Path.GetDirectoryName(System.Reflectio n.Assembly.GetExecutingAssembly().GetName().CodeBase),
"TesisBD_ES.sdf") + ";Max Database Size=2047"))); {
string sql = @"Insert into Producto(Descripcion, Stock)values('" + Descripcion + "', 0)";
conn.Open();
System.Data.SqlServerCe.SqlCeCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
SqlCeDataAdapter da = newSqlCeDataAdapter(cmd); da.Fill(dat);
conn.Close(); }
return"OK"; }
publicstaticstring Modificar(int Codigo, string Descripcion) {
TesisBD_ESDataSet.ProductoDataTable dat = newTesisBD_ESDataSet.ProductoDataTable();
System.Data.SqlServerCe.SqlCeConnection conn = new System.Data.SqlServerCe.SqlCeConnection(
("Data Source=" +
(System.IO.Path.Combine(System.IO.Path.GetDirectoryName(System.Reflectio n.Assembly.GetExecutingAssembly().GetName().CodeBase),
"TesisBD_ES.sdf") + ";Max Database Size=2047"))); {
string sql = @"Update Producto Set Descripcion ='" + Descripcion + "' Where Codigo=" + Codigo; conn.Open(); System.Data.SqlServerCe.SqlCeCommand cmd = conn.CreateCommand(); cmd.CommandText = sql; cmd.ExecuteNonQuery(); conn.Close(); } return"OK"; }
publicstaticstring Eliminar(int Codigo) {
TesisBD_ESDataSet.ProductoDataTable dat = newTesisBD_ESDataSet.ProductoDataTable();
System.Data.SqlServerCe.SqlCeConnection conn = new System.Data.SqlServerCe.SqlCeConnection(
("Data Source=" +
(System.IO.Path.Combine(System.IO.Path.GetDirectoryName(System.Reflectio n.Assembly.GetExecutingAssembly().GetName().CodeBase),
"TesisBD_ES.sdf") + ";Max Database Size=2047"))); {
string sql = @"Delete from Producto Where Codigo=" + Codigo; conn.Open(); System.Data.SqlServerCe.SqlCeCommand cmd = conn.CreateCommand(); cmd.CommandText = sql; cmd.ExecuteNonQuery(); conn.Close(); } return"OK"; }
publicstaticProducto ObtieneProducto(int Codigo) {
Producto MiProducto = newProducto();
System.Data.SqlServerCe.SqlCeConnection cn = new System.Data.SqlServerCe.SqlCeConnection(
("Data Source=" +
(System.IO.Path.Combine(System.IO.Path.GetDirectoryName(System.Reflectio n.Assembly.GetExecutingAssembly().GetName().CodeBase),
"TesisBD_ES.sdf") + ";Max Database Size=2047")));
TesisBD_ESDataSet.ProductoDataTable dat = newTesisBD_ESDataSet.ProductoDataTable();
SqlCeCommand cmd = newSqlCeCommand(); cmd.Connection = cn;
string sql = @"Select * from Producto where Codigo = " + Codigo; cmd.CommandText = sql;
SqlCeDataAdapter da = newSqlCeDataAdapter(cmd); da.Fill(dat);
cn.Open();
SqlCeDataReader reader = cmd.ExecuteReader(); do { reader.Read(); MiProducto.Descripcion = reader.GetString(1).Trim(); MiProducto.Stock = reader.GetInt32(2); } while (reader.NextResult()); reader.Close(); cn.Close(); return MiProducto; }
publicstaticint ActualizaStock(int Codigo, string Operacion, int Cantidad) {
Producto MiProducto = newProducto(); int Cant2;
TesisBD_ESDataSet.ProductoDataTable dat = newTesisBD_ESDataSet.ProductoDataTable();
System.Data.SqlServerCe.SqlCeConnection conn = new System.Data.SqlServerCe.SqlCeConnection(
("Data Source=" +
(System.IO.Path.Combine(System.IO.Path.GetDirectoryName(System.Reflectio n.Assembly.GetExecutingAssembly().GetName().CodeBase),
"TesisBD_ES.sdf") + ";Max Database Size=2047"))); {
string sql = @"Update Producto Set Stock = Stock " + Operacion + Cantidad.ToString() +" Where Codigo=" + Codigo;
conn.Open(); System.Data.SqlServerCe.SqlCeCommand cmd = conn.CreateCommand(); cmd.CommandText = sql; cmd.ExecuteNonQuery(); conn.Close();
TesisBD_ESDataSet.ProductoDataTable dat2 = newTesisBD_ESDataSet.ProductoDataTable();
SqlCeCommand cmd2 = newSqlCeCommand(); cmd2.Connection = conn;
sql = @"Select Stock from Producto where Codigo = " + Codigo; cmd.CommandText = sql;
SqlCeDataAdapter da = newSqlCeDataAdapter(cmd); da.Fill(dat2);
conn.Open();
SqlCeDataReader reader = cmd.ExecuteReader(); do { reader.Read(); MiProducto.Stock = reader.GetInt32(0); } while (reader.NextResult()); reader.Close(); conn.Close(); Cant2 = MiProducto.Stock; } return Cant2; } }
} CLASE PROVEEDOR using System; using System.Linq; using System.Collections.Generic; using System.Text; using System.Data.SqlServerCe; using System.Data; namespace Tesis_ES_Movil.Proveedores { publicclassProveedor { publicint Codigo; publicstring Nombre; publicstring Direccion; publicstring Telefono; publicstring Ruc;
publicstaticTesisBD_ESDataSet.ProveedorDataTable llenarProveedor() {
TesisBD_ESDataSet.ProveedorDataTable dat = newTesisBD_ESDataSet.ProveedorDataTable();
System.Data.SqlServerCe.SqlCeConnection conn = new System.Data.SqlServerCe.SqlCeConnection(
("Data Source=" +
(System.IO.Path.Combine(System.IO.Path.GetDirectoryName(System.Reflectio n.Assembly.GetExecutingAssembly().GetName().CodeBase),
"TesisBD_ES.sdf") + ";Max Database Size=2047"))); {
conn.Open();
string sql = @"select * FROM Proveedor";
System.Data.SqlServerCe.SqlCeCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
SqlCeDataAdapter da = newSqlCeDataAdapter(cmd); da.Fill(dat);
conn.Close(); }
return dat; }
publicstaticstring Insertar(string Nombre, string Direccion, string Telefono, string Ruc)
TesisBD_ESDataSet.ProveedorDataTable dat = newTesisBD_ESDataSet.ProveedorDataTable();
System.Data.SqlServerCe.SqlCeConnection conn = new System.Data.SqlServerCe.SqlCeConnection(
("Data Source=" +
(System.IO.Path.Combine(System.IO.Path.GetDirectoryName(System.Reflectio n.Assembly.GetExecutingAssembly().GetName().CodeBase),
"TesisBD_ES.sdf") + ";Max Database Size=2047"))); {
string sql = @"Insert into Proveedor(Nombre, Direccion, Telefono, Ruc)values('" + Nombre + "','" + Direccion + "','" + Telefono + "','" + Ruc + "' )";
conn.Open();
System.Data.SqlServerCe.SqlCeCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
SqlCeDataAdapter da = newSqlCeDataAdapter(cmd); da.Fill(dat);
conn.Close(); }
return"OK"; }
publicstaticstring Modificar(int Codigo, string Nombre, string Direccion, string Telefono, string Ruc)
{
TesisBD_ESDataSet.ProveedorDataTable dat = newTesisBD_ESDataSet.ProveedorDataTable();
System.Data.SqlServerCe.SqlCeConnection conn = new System.Data.SqlServerCe.SqlCeConnection(
("Data Source=" +
(System.IO.Path.Combine(System.IO.Path.GetDirectoryName(System.Reflectio n.Assembly.GetExecutingAssembly().GetName().CodeBase),
"TesisBD_ES.sdf") + ";Max Database Size=2047"))); {
string sql = @"Update Proveedor Set Nombre ='" + Nombre + "', Direccion='" + Direccion + "', Telefono='"+Telefono + "', Ruc='"+Ruc+"' Where Codigo=" + Codigo; conn.Open(); System.Data.SqlServerCe.SqlCeCommand cmd = conn.CreateCommand(); cmd.CommandText = sql; cmd.ExecuteNonQuery(); conn.Close(); } return"OK"; }
{
TesisBD_ESDataSet.ProveedorDataTable dat = newTesisBD_ESDataSet.ProveedorDataTable();
System.Data.SqlServerCe.SqlCeConnection conn = new System.Data.SqlServerCe.SqlCeConnection(
("Data Source=" +
(System.IO.Path.Combine(System.IO.Path.GetDirectoryName(System.Reflectio n.Assembly.GetExecutingAssembly().GetName().CodeBase),
"TesisBD_ES.sdf") + ";Max Database Size=2047"))); {
string sql = @"Delete from Proveedor Where Codigo=" + Codigo; conn.Open(); System.Data.SqlServerCe.SqlCeCommand cmd = conn.CreateCommand(); cmd.CommandText = sql; cmd.ExecuteNonQuery(); conn.Close(); } return"OK"; }
publicstaticProveedor ObtieneProveedor(int Codigo) {
Proveedor MiProveedor = newProveedor();
System.Data.SqlServerCe.SqlCeConnection cn = new System.Data.SqlServerCe.SqlCeConnection(
("Data Source=" +
(System.IO.Path.Combine(System.IO.Path.GetDirectoryName(System.Reflectio n.Assembly.GetExecutingAssembly().GetName().CodeBase),
"TesisBD_ES.sdf") + ";Max Database Size=2047")));
TesisBD_ESDataSet.ProveedorDataTable dat = newTesisBD_ESDataSet.ProveedorDataTable();
SqlCeCommand cmd = newSqlCeCommand(); cmd.Connection = cn;
string sql = @"Select * from Proveedor where Codigo = " + Codigo; cmd.CommandText = sql;
SqlCeDataAdapter da = newSqlCeDataAdapter(cmd); da.Fill(dat);
cn.Open();
SqlCeDataReader reader = cmd.ExecuteReader(); do { reader.Read(); MiProveedor.Nombre = reader.GetString(1).Trim(); MiProveedor.Direccion = reader.GetString(2).Trim(); MiProveedor.Telefono = reader.GetString(3).Trim(); MiProveedor.Ruc = reader.GetString(4).Trim(); } while (reader.NextResult());
reader.Close(); cn.Close(); return MiProveedor; } // } } CLASE ROL using System; using System.Linq; using System.Collections.Generic; using System.Text; using System.Data.SqlServerCe; using System.Data; namespace Tesis_ES_Movil { publicclassRol {
publicstaticTesisBD_ESDataSet.RolDataTable llenarRol() {
TesisBD_ESDataSet.RolDataTable dat = newTesisBD_ESDataSet.RolDataTable();
System.Data.SqlServerCe.SqlCeConnection conn = new System.Data.SqlServerCe.SqlCeConnection(
("Data Source=" +
(System.IO.Path.Combine(System.IO.Path.GetDirectoryName(System.Reflectio n.Assembly.GetExecutingAssembly().GetName().CodeBase),
"TesisBD_ES.sdf") + ";Max Database Size=2047"))); {
conn.Open();
string sql = @"select * FROM Rol";
System.Data.SqlServerCe.SqlCeCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
SqlCeDataAdapter da = newSqlCeDataAdapter(cmd); da.Fill(dat);
conn.Close(); }
return dat; }
publicstaticstring Insertar(string Descripcion) {
TesisBD_ESDataSet.RolDataTable dat = newTesisBD_ESDataSet.RolDataTable();
System.Data.SqlServerCe.SqlCeConnection conn = new System.Data.SqlServerCe.SqlCeConnection(
("Data Source=" +
(System.IO.Path.Combine(System.IO.Path.GetDirectoryName(System.Reflectio n.Assembly.GetExecutingAssembly().GetName().CodeBase),
"TesisBD_ES.sdf") + ";Max Database Size=2047"))); {
string sql = @"Insert into Rol(Descripcion)values('"+Descripcion+"')"; conn.Open();
System.Data.SqlServerCe.SqlCeCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
SqlCeDataAdapter da = newSqlCeDataAdapter(cmd); da.Fill(dat);
conn.Close(); }
return"OK"; }
publicstaticstring Modificar(int Codigo, string Descripcion) {
TesisBD_ESDataSet.RolDataTable dat = newTesisBD_ESDataSet.RolDataTable();
System.Data.SqlServerCe.SqlCeConnection conn = new System.Data.SqlServerCe.SqlCeConnection(
("Data Source=" +
(System.IO.Path.Combine(System.IO.Path.GetDirectoryName(System.Reflectio n.Assembly.GetExecutingAssembly().GetName().CodeBase),
"TesisBD_ES.sdf") + ";Max Database Size=2047"))); {
string sql = @"Update Rol Set Descripcion ='" + Descripcion + "' Where Codigo=" + Codigo; conn.Open(); System.Data.SqlServerCe.SqlCeCommand cmd = conn.CreateCommand(); cmd.CommandText = sql; cmd.ExecuteNonQuery(); conn.Close(); } return"OK"; }
publicstaticstring Eliminar(int Codigo) {
TesisBD_ESDataSet.RolDataTable dat = newTesisBD_ESDataSet.RolDataTable();
System.Data.SqlServerCe.SqlCeConnection conn = new System.Data.SqlServerCe.SqlCeConnection(
("Data Source=" +
(System.IO.Path.Combine(System.IO.Path.GetDirectoryName(System.Reflectio n.Assembly.GetExecutingAssembly().GetName().CodeBase),
"TesisBD_ES.sdf") + ";Max Database Size=2047"))); {
string sql = @"Delete from Rol Where Codigo=" + Codigo; conn.Open(); System.Data.SqlServerCe.SqlCeCommand cmd = conn.CreateCommand(); cmd.CommandText = sql; cmd.ExecuteNonQuery(); conn.Close(); } return"OK"; }
publicstaticstring ObtieneRol(int Codigo) {
string Descripcion;
System.Data.SqlServerCe.SqlCeConnection cn = new System.Data.SqlServerCe.SqlCeConnection(
("Data Source=" +
(System.IO.Path.Combine(System.IO.Path.GetDirectoryName(System.Reflectio n.Assembly.GetExecutingAssembly().GetName().CodeBase),
"TesisBD_ES.sdf") + ";Max Database Size=2047")));
TesisBD_ESDataSet.RolDataTable dat = newTesisBD_ESDataSet.RolDataTable();
SqlCeCommand cmd = newSqlCeCommand(); cmd.Connection = cn;
string sql = @"Select * from Rol where Codigo = " + Codigo; cmd.CommandText = sql;
SqlCeDataAdapter da = newSqlCeDataAdapter(cmd); da.Fill(dat);
cn.Open();
SqlCeDataReader reader = cmd.ExecuteReader(); do
{
reader.Read();
Descripcion = reader.GetString(1).Trim(); } while (reader.NextResult());
reader.Close(); cn.Close(); return Descripcion; } } } CLASE USUARIO using System; using System.Linq; using System.Collections.Generic; using System.Text; using System.Data.SqlServerCe; using System.Data; namespace Tesis_ES_Movil.Usuarios { publicclassUsuario { publicint Codigo; publicstring Descripcion; publicint Rol; publicstring Clave;
publicstaticTesisBD_ESDataSet.UsuarioDataTable llenarUsuario() {
TesisBD_ESDataSet.UsuarioDataTable dat = newTesisBD_ESDataSet.UsuarioDataTable();
System.Data.SqlServerCe.SqlCeConnection conn = new System.Data.SqlServerCe.SqlCeConnection(
("Data Source=" +
(System.IO.Path.Combine(System.IO.Path.GetDirectoryName(System.Reflectio n.Assembly.GetExecutingAssembly().GetName().CodeBase),
"TesisBD_ES.sdf") + ";Max Database Size=2047"))); {
conn.Open();
string sql = @"select * FROM Usuario";
System.Data.SqlServerCe.SqlCeCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
SqlCeDataAdapter da = newSqlCeDataAdapter(cmd); da.Fill(dat);
conn.Close(); }
}
publicstaticstring Insertar(string Descripcion, int CodRol, string Clave) {
TesisBD_ESDataSet.UsuarioDataTable dat = newTesisBD_ESDataSet.UsuarioDataTable();
System.Data.SqlServerCe.SqlCeConnection conn = new System.Data.SqlServerCe.SqlCeConnection(
("Data Source=" +
(System.IO.Path.Combine(System.IO.Path.GetDirectoryName(System.Reflectio n.Assembly.GetExecutingAssembly().GetName().CodeBase),
"TesisBD_ES.sdf") + ";Max Database Size=2047"))); {
string sql = @"Insert into Usuario(Nombre, Rol, Clave)values('" + Descripcion + "',"+CodRol+",'" + Clave + "' )";
conn.Open();
System.Data.SqlServerCe.SqlCeCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
SqlCeDataAdapter da = newSqlCeDataAdapter(cmd); da.Fill(dat);
conn.Close(); }
return"OK"; }
publicstaticstring Modificar(int Codigo, string Descripcion, int CodRol, string Clave)
{
TesisBD_ESDataSet.UsuarioDataTable dat = newTesisBD_ESDataSet.UsuarioDataTable();
System.Data.SqlServerCe.SqlCeConnection conn = new System.Data.SqlServerCe.SqlCeConnection(
("Data Source=" +
(System.IO.Path.Combine(System.IO.Path.GetDirectoryName(System.Reflectio n.Assembly.GetExecutingAssembly().GetName().CodeBase),
"TesisBD_ES.sdf") + ";Max Database Size=2047"))); {
string sql = @"Update Usuario Set Nombre ='" + Descripcion + "', Rol="+ CodRol +", Clave = '"+ Clave +"' Where Codigo=" + Codigo;
conn.Open(); System.Data.SqlServerCe.SqlCeCommand cmd = conn.CreateCommand(); cmd.CommandText = sql; cmd.ExecuteNonQuery(); conn.Close(); } return"OK";
}
publicstaticstring Eliminar(int Codigo) {
TesisBD_ESDataSet.UsuarioDataTable dat = newTesisBD_ESDataSet.UsuarioDataTable();
System.Data.SqlServerCe.SqlCeConnection conn = new System.Data.SqlServerCe.SqlCeConnection(
("Data Source=" +
(System.IO.Path.Combine(System.IO.Path.GetDirectoryName(System.Reflectio n.Assembly.GetExecutingAssembly().GetName().CodeBase),
"TesisBD_ES.sdf") + ";Max Database Size=2047"))); {
string sql = @"Delete from Usuario Where Codigo=" + Codigo; conn.Open(); System.Data.SqlServerCe.SqlCeCommand cmd = conn.CreateCommand(); cmd.CommandText = sql; cmd.ExecuteNonQuery(); conn.Close(); } return"OK"; }
publicstaticUsuario ObtieneUsuario(int Codigo) {
Usuario MiUsuario = newUsuario();
System.Data.SqlServerCe.SqlCeConnection cn = new System.Data.SqlServerCe.SqlCeConnection(
("Data Source=" +
(System.IO.Path.Combine(System.IO.Path.GetDirectoryName(System.Reflectio n.Assembly.GetExecutingAssembly().GetName().CodeBase),
"TesisBD_ES.sdf") + ";Max Database Size=2047")));
TesisBD_ESDataSet.UsuarioDataTable dat = newTesisBD_ESDataSet.UsuarioDataTable();
SqlCeCommand cmd = newSqlCeCommand(); cmd.Connection = cn;
string sql = @"Select * from Usuario where Codigo = " + Codigo; cmd.CommandText = sql;
SqlCeDataAdapter da = newSqlCeDataAdapter(cmd); da.Fill(dat);
cn.Open();
SqlCeDataReader reader = cmd.ExecuteReader(); do
{
reader.Read();
MiUsuario.Descripcion = reader.GetString(1).Trim(); MiUsuario.Rol = reader.GetInt32(2);
MiUsuario.Clave = reader.GetString(3); } while (reader.NextResult()); reader.Close(); cn.Close(); return MiUsuario; } } } ORGANIZACIÓN
Debemos ser organizados en nuestra programación para poder realizar