public string AgregarDetalleFactura(int id, int id_producto, int cantidad, int precio)
{
try
{
using (cmd = new SqlCommand("exec sp_AgregarDetalleFactura @id, @id_producto, @cantidad, @precio", con))
{
cmd.Parameters.Add(new SqlParameter("@id", id));
cmd.Parameters.Add(new SqlParameter("@id_producto", id_producto));
cmd.Parameters.Add(new SqlParameter("@cantidad", cantidad));
cmd.Parameters.Add(new SqlParameter("@precio", precio));
reader = cmd.ExecuteReader();
return("1");
}
}
catch (SqlException ex)
{
cLogWriter log = new cLogWriter("ERROR: " + ex.ToString());
return(ex.Message);
}
catch (Exception ex)
{
return(ex.Message);
}
}
public bool VerificarCliente(int ced)
{
bool passed;
using (cmd = new SqlCommand("SELECT cedula FROM Clientes where cedula = @cedula", con))
{
cmd.Parameters.Add(new SqlParameter("@cedula", ced));
try
{
reader = cmd.ExecuteReader();
}
catch (Exception ex)
{
cLogWriter log = new cLogWriter("ERROR: " + ex.ToString());
passed = false;
}
if (reader.Read())
{
passed = true;
}
else
{
passed = false;
}
reader.Close();
return(passed);
}
}
public string EliminarProducto(int id)
{
try
{
using (cmd = new SqlCommand("delete from Productos where id = @id", con))
{
cmd.Parameters.Add(new SqlParameter("@id", id));
using (var tran = con.BeginTransaction())
{
cmd.Transaction = tran;
reader = cmd.ExecuteReader();
tran.Commit();
}
return("1");
}
}
catch (SqlException ex)
{
cLogWriter log = new cLogWriter("ERROR: " + ex.ToString());
return(ex.Message);
}
catch (Exception ex)
{
return(ex.Message);
}
}
public string AgregarFactura(int cedula)
{
string id;
try
{
using (cmd = new SqlCommand("exec sp_AgregarFactura @cedula", con))
{
cmd.Parameters.Add(new SqlParameter("@cedula", cedula));
object obj = cmd.ExecuteScalar();
id = obj.ToString();
return(id);
}
}
catch (SqlException ex)
{
cLogWriter log = new cLogWriter("ERROR: " + ex.ToString());
return(ex.Message);
}
catch (Exception ex)
{
return(ex.Message);
}
}
public string ModificarEmpleado(int ced, int nueva_ced, string nombre, string apellido, string pwd)
{
try
{
using (cmd = new SqlCommand("exec sp_ModificarEmpleado @cedula, @nueva_ced, @nombre, @apellido, @pwd", con))
{
cmd.Parameters.Add(new SqlParameter("@cedula", ced));
cmd.Parameters.Add(new SqlParameter("@nueva_ced", nueva_ced));
cmd.Parameters.Add(new SqlParameter("@nombre", nombre));
cmd.Parameters.Add(new SqlParameter("@apellido", apellido));
if (pwd != "")
{
cmd.Parameters.Add(new SqlParameter("@pwd", cEncrypt.GetMD5(pwd)));
}
else
{
cmd.Parameters.Add(new SqlParameter("@pwd", ""));
}
reader = cmd.ExecuteReader();
return("1");
}
}
catch (SqlException ex)
{
cLogWriter log = new cLogWriter("ERROR: " + ex.ToString());
return(ex.Message);
}
catch (Exception ex)
{
return(ex.Message);
}
}
public cEmpleado LoginEmpleado(int ced, string pwd)
{
using (cmd = new SqlCommand("SELECT cedula, nombre, apellido, pwd FROM Empleados where cedula = @cedula AND pwd = @pwd", con))
{
cmd.Parameters.Add(new SqlParameter("@cedula", ced));
cmd.Parameters.Add(new SqlParameter("@pwd", cEncrypt.GetMD5(pwd)));
try
{
reader = cmd.ExecuteReader();
}
catch (Exception ex)
{
cLogWriter log = new cLogWriter("ERROR: " + ex.ToString());
return(null);
}
if (reader.Read())
{
int cedula_ = reader.GetInt32(0);
string nombre_ = reader.GetString(1);
string apellido_ = reader.GetString(2);
reader.Close();
return(new cEmpleado(cedula_, nombre_, apellido_));
}
else
{
return(null);
}
}
}
public cEmpleado GetEmpleado(int ced)
{
using (cmd = new SqlCommand("SELECT cedula, nombre, apellido, pwd FROM Empleados where cedula = @cedula", con))
{
cmd.Parameters.Add(new SqlParameter("@cedula", ced));
try
{
reader = cmd.ExecuteReader();
}
catch (Exception ex)
{
cLogWriter log = new cLogWriter("ERROR: " + ex.ToString());
return(null);
}
if (reader.Read())
{
return(new cEmpleado(reader.GetInt32(0), reader.GetString(1), reader.GetString(2)));
}
else
{
return(null);
}
}
}
public string CrearEmpleado(int ced, string nombre, string apellido, string pwd)
{
try
{
using (cmd = new SqlCommand("INSERT INTO Empleados VALUES (@cedula, @nombre, @apellido, @pwd)", con))
{
cmd.Parameters.Add(new SqlParameter("@cedula", ced));
cmd.Parameters.Add(new SqlParameter("@nombre", nombre));
cmd.Parameters.Add(new SqlParameter("@apellido", apellido));
cmd.Parameters.Add(new SqlParameter("@pwd", cEncrypt.GetMD5(pwd)));
reader = cmd.ExecuteReader();
return("1");
}
}
catch (SqlException ex)
{
cLogWriter log = new cLogWriter("ERROR: " + ex.ToString());
return(ex.Message);
}
catch (Exception ex)
{
return(ex.Message);
}
}
public ServicioWCF()
{
try
{
con = new SqlConnection(strCon);
con.Open();
}
catch (Exception ex)
{
cLogWriter log = new cLogWriter("ERROR: " + ex.ToString());
}
}
public string AlterarProducto(int id, string nombre, string descripcion, int precio, int cantidad, int proveedor, int tipo)
{
try
{
if (id != 0)
{
using (cmd = new SqlCommand("exec sp_ModificarProducto @id, @nombre, @descripcion, @precio, @cantidad, @proveedor, @tipo", con))
{
cmd.Parameters.Add(new SqlParameter("@id", id));
cmd.Parameters.Add(new SqlParameter("@nombre", nombre));
cmd.Parameters.Add(new SqlParameter("@descripcion", descripcion));
cmd.Parameters.Add(new SqlParameter("@precio", precio));
cmd.Parameters.Add(new SqlParameter("@cantidad", cantidad));
cmd.Parameters.Add(new SqlParameter("@proveedor", proveedor));
cmd.Parameters.Add(new SqlParameter("@tipo", tipo));
reader = cmd.ExecuteReader();
return("modificado");
}
}
else
{
using (cmd = new SqlCommand("exec sp_AgregarProducto @nombre, @descripcion, @precio, @cantidad, @proveedor, @tipo", con))
{
cmd.Parameters.Add(new SqlParameter("@nombre", nombre));
cmd.Parameters.Add(new SqlParameter("@descripcion", descripcion));
cmd.Parameters.Add(new SqlParameter("@precio", precio));
cmd.Parameters.Add(new SqlParameter("@cantidad", cantidad));
cmd.Parameters.Add(new SqlParameter("@proveedor", proveedor));
cmd.Parameters.Add(new SqlParameter("@tipo", tipo));
reader = cmd.ExecuteReader();
return("creado");
}
}
}
catch (SqlException ex)
{
cLogWriter log = new cLogWriter("ERROR: " + ex.ToString());
return(ex.Message);
}
catch (Exception ex)
{
return(ex.Message);
}
}
public string AlterarCliente(int id, int cedula, string nombre, string apellido, string telefono)
{
try
{
if (id != 0)
{
using (cmd = new SqlCommand("exec sp_ModificarCliente @id, @cedula, @nombre, @apellido, @telefono", con))
{
cmd.Parameters.Add(new SqlParameter("@id", id));
cmd.Parameters.Add(new SqlParameter("@cedula", cedula));
cmd.Parameters.Add(new SqlParameter("@nombre", nombre));
cmd.Parameters.Add(new SqlParameter("@apellido", apellido));
cmd.Parameters.Add(new SqlParameter("@telefono", telefono));
reader = cmd.ExecuteReader();
return("modificado");
}
}
else
{
using (cmd = new SqlCommand("exec sp_AgregarCliente @cedula, @nombre, @apellido, @telefono", con))
{
cmd.Parameters.Add(new SqlParameter("@cedula", cedula));
cmd.Parameters.Add(new SqlParameter("@nombre", nombre));
cmd.Parameters.Add(new SqlParameter("@apellido", apellido));
cmd.Parameters.Add(new SqlParameter("@telefono", telefono));
reader = cmd.ExecuteReader();
return("creado");
}
}
}
catch (SqlException ex)
{
cLogWriter log = new cLogWriter("ERROR: " + ex.ToString());
return(ex.Message);
}
catch (Exception ex)
{
cLogWriter log = new cLogWriter("ERROR: " + ex.ToString());
return(ex.Message);
}
}
public string AlterarProveedor(int id, string nombre, string rif, string dir_fiscal)
{
try
{
if (id != 0)
{
using (cmd = new SqlCommand("exec sp_ModificarProveedor @id, @nombre, @rif, @dir_fiscal", con))
{
cmd.Parameters.Add(new SqlParameter("@id", id));
cmd.Parameters.Add(new SqlParameter("@nombre", nombre));
cmd.Parameters.Add(new SqlParameter("@rif", rif));
cmd.Parameters.Add(new SqlParameter("@dir_fiscal", dir_fiscal));
reader = cmd.ExecuteReader();
return("modificado");
}
}
else
{
using (cmd = new SqlCommand("exec sp_AgregarProveedor @nombre, @rif, @dir_fiscal", con))
{
cmd.Parameters.Add(new SqlParameter("@nombre", nombre));
cmd.Parameters.Add(new SqlParameter("@rif", rif));
cmd.Parameters.Add(new SqlParameter("@dir_fiscal", dir_fiscal));
reader = cmd.ExecuteReader();
return("creado");
}
}
}
catch (SqlException ex)
{
cLogWriter log = new cLogWriter("ERROR: " + ex.ToString());
return(ex.Message);
}
catch (Exception ex)
{
return(ex.Message);
}
}
public DataTable GetDataTable(string tabla)
{
DataTable dt = new DataTable();
dt.TableName = tabla;
try
{
using (cmd = new SqlCommand("select * from " + tabla, con))
{
dAdap = new SqlDataAdapter(cmd);
dAdap.Fill(dt);
}
}
catch (Exception ex)
{
cLogWriter log = new cLogWriter("ERROR: " + ex.ToString());
}
return(dt);
}
public string AlterarTipoProducto(int id, string descripcion)
{
try
{
if (id != 0)
{
using (cmd = new SqlCommand("exec sp_ModificarTipoProducto @id, @descripcion", con))
{
cmd.Parameters.Add(new SqlParameter("@id", id));
cmd.Parameters.Add(new SqlParameter("@descripcion", descripcion));
reader = cmd.ExecuteReader();
return("modificado");
}
}
else
{
using (cmd = new SqlCommand("exec sp_AgregarTipoProducto @descripcion", con))
{
cmd.Parameters.Add(new SqlParameter("@descripcion", descripcion));
reader = cmd.ExecuteReader();
return("creado");
}
}
}
catch (SqlException ex)
{
cLogWriter log = new cLogWriter("ERROR: " + ex.ToString());
return(ex.Message);
}
catch (Exception ex)
{
return(ex.Message);
}
}
public string EliminarDeTabla(int id, string tabla)
{
try
{
using (cmd = new SqlCommand("delete from " + tabla + " where id = @id", con))
{
cmd.Parameters.Add(new SqlParameter("@id", id));
reader = cmd.ExecuteReader();
return("1");
}
}
catch (SqlException ex)
{
cLogWriter log = new cLogWriter("ERROR: " + ex.ToString());
return(ex.Message);
}
catch (Exception ex)
{
return(ex.Message);
}
}
