public DataTable ListarCliente(BECliente objECliente) { DataTable dt = new DataTable(); MySqlConnection conn = new MySqlConnection("Server=127.0.0.1; Database=MECANICSWEB; Uid=Administrador; Pwd=admin"); MySqlCommand command = new MySqlCommand("`mecanicsweb`.`ListarCliente`", conn); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(ObjSqlParameter("N_ID", objECliente.ID_Cliente, ParameterDirection.Input, System.Data.DbType.String)); conn.Open(); IDataReader dr = command.ExecuteReader(); dt.Load(dr); conn.Close(); return dt; }
public Object MantenimientoCliente(string ACCION, BECliente objECliente) { DataTable dt = new DataTable(); MySqlConnection conn = new MySqlConnection("Server=127.0.0.1; Database=MECANICSWEB; Uid=Administrador; Pwd=admin"); MySqlCommand command = new MySqlCommand("`mecanicsweb`.`MantenimientoCliente`", conn); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(ObjSqlParameter("N_ID", objECliente.ID_Cliente, ParameterDirection.Input, System.Data.DbType.Int16)); command.Parameters.Add(ObjSqlParameter("N_IDContacto", objECliente.ID_Contacto, ParameterDirection.Input, System.Data.DbType.String)); command.Parameters.Add(ObjSqlParameter("N_IDVehiculo", objECliente.ID_Vehiculo, ParameterDirection.Input, System.Data.DbType.String)); command.Parameters.Add(ObjSqlParameter("N_Tipo", objECliente.Tipo, ParameterDirection.Input, System.Data.DbType.Int16)); command.Parameters.Add(ObjSqlParameter("N_Nombre", objECliente.Nombre, ParameterDirection.Input, System.Data.DbType.String)); command.Parameters.Add(ObjSqlParameter("N_RazonSocial", objECliente.RazonSocial, ParameterDirection.Input, System.Data.DbType.String)); command.Parameters.Add(ObjSqlParameter("N_Documento", objECliente.Documento, ParameterDirection.Input, System.Data.DbType.String)); command.Parameters.Add(ObjSqlParameter("N_Direccion", objECliente.Direccion, ParameterDirection.Input, System.Data.DbType.String)); command.Parameters.Add(ObjSqlParameter("N_Distrito", objECliente.Distrito, ParameterDirection.Input, System.Data.DbType.String)); command.Parameters.Add(ObjSqlParameter("N_Telefono", objECliente.Telefono, ParameterDirection.Input, System.Data.DbType.String)); command.Parameters.Add(ObjSqlParameter("N_Email", objECliente.Email, ParameterDirection.Input, System.Data.DbType.String)); command.Parameters.Add(ObjSqlParameter("N_PaginaWeb", objECliente.PaginaWeb, ParameterDirection.Input, System.Data.DbType.String)); command.Parameters.Add(ObjSqlParameter("ACCION", ACCION, ParameterDirection.Input, System.Data.DbType.String)); conn.Open(); try { if (ACCION.Equals("AGREGAR") || ACCION.Equals("MODIFICAR")) { command.ExecuteNonQuery(); return "Exito"; } else { IDataReader dr = command.ExecuteReader(); dt.Load(dr); return dt; } } catch (Exception e) { throw new Exception("Error interno", e); } finally { conn.Close(); } }
public DataTable ListarCliente(BECliente objECliente) { return objCliente.ListarCliente(objECliente); }
public Object MantenimientoCliente(string ACCION, BECliente objECliente) { return objCliente.MantenimientoCliente(ACCION, objECliente); }
public DataTable ConsultarCliente(BECliente objECliente) { return objCliente.ConsultarCliente(objECliente); }