Exemple #1
0
 public void borrarDept(int dept_id)
 {
     dbConnect ObjConexionDB = new dbConnect();
     SqlConnection cn = new SqlConnection(ObjConexionDB.connect());
     cn.Open();
     SqlCommand cmd = new SqlCommand("spEliminarDepartamento", cn);
     cmd.CommandType = CommandType.StoredProcedure;
     cmd.Parameters.AddWithValue("@dept_id", dept_id);
     cmd.ExecuteNonQuery();
     cn.Close();
 }
Exemple #2
0
 public void nuevoDept(string dept_desc, int emp_id)
 {
     dbConnect ObjConexionDB = new dbConnect();
     SqlConnection cn = new SqlConnection(ObjConexionDB.connect());
     cn.Open();
     SqlCommand cmd = new SqlCommand("spNuevoDepartamento", cn);
     cmd.CommandType = CommandType.StoredProcedure;
     cmd.Parameters.AddWithValue("@emp_id", emp_id);
     cmd.Parameters.AddWithValue("@dept_desc", dept_desc);
     cmd.ExecuteNonQuery();
     cn.Close();
 }
Exemple #3
0
 public DataTable consultaTodosDept()
 {
     dbConnect ObjConexionDB = new dbConnect();
     DataSet dsDept = new DataSet();
     SqlConnection cn = new SqlConnection(ObjConexionDB.connect());
     cn.Open();
     SqlCommand cmd = new SqlCommand("spConsultaTodosDept", cn);
     cmd.CommandType = CommandType.StoredProcedure;
     SqlDataAdapter SqlDa = new SqlDataAdapter(cmd);
     SqlDa.Fill(dsDept);
     cn.Close();
     return dsDept.Tables[0];
 }
Exemple #4
0
        public void borrarDept(int dept_id)
        {
            dbConnect     ObjConexionDB = new dbConnect();
            SqlConnection cn            = new SqlConnection(ObjConexionDB.connect());

            cn.Open();
            SqlCommand cmd = new SqlCommand("spEliminarDepartamento", cn);

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@dept_id", dept_id);
            cmd.ExecuteNonQuery();
            cn.Close();
        }
Exemple #5
0
        public void eliminarEmpleado(int emp_id)
        {
            dbConnect     ObjConexionDB = new dbConnect();
            DataSet       dsCliente     = new DataSet();
            SqlConnection cn            = new SqlConnection(ObjConexionDB.connect());

            cn.Open();
            SqlCommand cmd = new SqlCommand("spEliminarEmpleado", cn);

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@emp_id", emp_id);
            cmd.ExecuteNonQuery();
        }
Exemple #6
0
 public DataTable empDDL()
 {
     dbConnect ObjConexionDB = new dbConnect();
     DataSet dsDDL = new DataSet();
     SqlConnection cn = new SqlConnection(ObjConexionDB.connect());
     cn.Open();
     SqlCommand cmd = new SqlCommand("spBusquedaClienteDDL", cn);
     cmd.CommandType = CommandType.StoredProcedure;
     SqlDataAdapter SqlDa = new SqlDataAdapter(cmd);
     SqlDa.Fill(dsDDL);
     cn.Close();
     return dsDDL.Tables[0];
 }
Exemple #7
0
 public DataTable consultaID(int dept_id)
 {
     dbConnect ObjConexionDB = new dbConnect();
     DataSet dsDept = new DataSet();
     SqlConnection cn = new SqlConnection(ObjConexionDB.connect());
     cn.Open();
     SqlCommand cmd = new SqlCommand("spCsonultaDeptID", cn);
     cmd.CommandType = CommandType.StoredProcedure;
     cmd.Parameters.AddWithValue("@dept_id", dept_id);
     SqlDataAdapter SqlDa = new SqlDataAdapter(cmd);
     SqlDa.Fill(dsDept);
     cn.Close();
     return dsDept.Tables[0];
 }
Exemple #8
0
        public void nuevoDept(string dept_desc, int emp_id)
        {
            dbConnect     ObjConexionDB = new dbConnect();
            SqlConnection cn            = new SqlConnection(ObjConexionDB.connect());

            cn.Open();
            SqlCommand cmd = new SqlCommand("spNuevoDepartamento", cn);

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@emp_id", emp_id);
            cmd.Parameters.AddWithValue("@dept_desc", dept_desc);
            cmd.ExecuteNonQuery();
            cn.Close();
        }
Exemple #9
0
        public DataTable consultaTodosDept()
        {
            dbConnect     ObjConexionDB = new dbConnect();
            DataSet       dsDept        = new DataSet();
            SqlConnection cn            = new SqlConnection(ObjConexionDB.connect());

            cn.Open();
            SqlCommand cmd = new SqlCommand("spConsultaTodosDept", cn);

            cmd.CommandType = CommandType.StoredProcedure;
            SqlDataAdapter SqlDa = new SqlDataAdapter(cmd);

            SqlDa.Fill(dsDept);
            cn.Close();
            return(dsDept.Tables[0]);
        }
Exemple #10
0
        public DataTable empDDL()
        {
            dbConnect     ObjConexionDB = new dbConnect();
            DataSet       dsDDL         = new DataSet();
            SqlConnection cn            = new SqlConnection(ObjConexionDB.connect());

            cn.Open();
            SqlCommand cmd = new SqlCommand("spBusquedaClienteDDL", cn);

            cmd.CommandType = CommandType.StoredProcedure;
            SqlDataAdapter SqlDa = new SqlDataAdapter(cmd);

            SqlDa.Fill(dsDDL);
            cn.Close();
            return(dsDDL.Tables[0]);
        }
Exemple #11
0
        public DataTable consultaID(int dept_id)
        {
            dbConnect     ObjConexionDB = new dbConnect();
            DataSet       dsDept        = new DataSet();
            SqlConnection cn            = new SqlConnection(ObjConexionDB.connect());

            cn.Open();
            SqlCommand cmd = new SqlCommand("spCsonultaDeptID", cn);

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@dept_id", dept_id);
            SqlDataAdapter SqlDa = new SqlDataAdapter(cmd);

            SqlDa.Fill(dsDept);
            cn.Close();
            return(dsDept.Tables[0]);
        }
Exemple #12
0
        public void crearEmpleado(string emp_nombre, string emp_apellido,
                                  string emp_cedula, string emp_extension, string emp_flota,
                                  int dept_id)
        {
            dbConnect     ObjConexionDB = new dbConnect();
            DataSet       dsCliente     = new DataSet();
            SqlConnection cn            = new SqlConnection(ObjConexionDB.connect());

            cn.Open();
            SqlCommand cmd = new SqlCommand("spNuevoEmpleado", cn);

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@emp_nombre", emp_nombre);
            cmd.Parameters.AddWithValue("@emp_apellido", emp_apellido);
            cmd.Parameters.AddWithValue("@emp_cedula", emp_cedula);
            cmd.Parameters.AddWithValue("@dept_id", dept_id);
            cmd.Parameters.AddWithValue("@emp_ext", emp_extension);
            cmd.Parameters.AddWithValue("@emp_flota", emp_flota);
            cmd.ExecuteNonQuery();
        }
Exemple #13
0
        public void editarEmpleado(int emp_id, string emp_nombre, string emp_apellido,
                                   string emp_cedula, string emp_extension, string emp_flota,
                                   int dept_id)
        {
            dbConnect     ObjConexionDB = new dbConnect();
            SqlConnection cn            = new SqlConnection(ObjConexionDB.connect());

            cn.Open();
            SqlCommand cmd = new SqlCommand("spActEmpleado", cn);

            cmd.CommandType = CommandType.StoredProcedure;

            if (String.IsNullOrEmpty(emp_nombre))
            {
                cmd.Parameters.AddWithValue("@emp_nombre", System.Data.SqlTypes.SqlString.Null);
            }

            else
            {
                cmd.Parameters.AddWithValue("@emp_nombre", emp_nombre);
            }

            if (String.IsNullOrEmpty(emp_apellido))
            {
                cmd.Parameters.AddWithValue("@emp_apellido", System.Data.SqlTypes.SqlString.Null);
            }
            else
            {
                cmd.Parameters.AddWithValue("@emp_apellido", emp_apellido);
            }

            if (String.IsNullOrEmpty(emp_cedula))
            {
                cmd.Parameters.AddWithValue("@emp_cedula", System.Data.SqlTypes.SqlString.Null);
            }
            else
            {
                cmd.Parameters.AddWithValue("@emp_cedula", emp_cedula);
            }

            if (String.IsNullOrEmpty(emp_extension))
            {
                cmd.Parameters.AddWithValue("@emp_ext", System.Data.SqlTypes.SqlString.Null);
            }
            else
            {
                cmd.Parameters.AddWithValue("@emp_ext", emp_extension);
            }

            if (String.IsNullOrEmpty(emp_flota))
            {
                cmd.Parameters.AddWithValue("@emp_flota", System.Data.SqlTypes.SqlString.Null);
            }
            else
            {
                cmd.Parameters.AddWithValue("@emp_flota", emp_flota);
            }

            cmd.Parameters.AddWithValue("@dept_id", dept_id);
            cmd.Parameters.AddWithValue("@emp_id", emp_id);
            cmd.ExecuteNonQuery();

            //Fin de multiples formas de consultar

            SqlDataAdapter SqlDa = new SqlDataAdapter(cmd);

            cn.Close();
        }
Exemple #14
0
        public DataTable ConsultarEmpleado(string emp_parameter, int type)
        {
            dbConnect     ObjConexionDB = new dbConnect();
            DataSet       dsCliente     = new DataSet();
            SqlConnection cn            = new SqlConnection(ObjConexionDB.connect());

            cn.Open();
            SqlCommand cmd = new SqlCommand("spConsultaEmpleado", cn);

            cmd.CommandType = CommandType.StoredProcedure;
            //Condiciones para multiples formas de consulta
            if (type == 1)
            {
                cmd.Parameters.AddWithValue("@emp_nombre", emp_parameter);
            }
            else
            {
                cmd.Parameters.AddWithValue("@emp_nombre", System.Data.SqlTypes.SqlString.Null);
            }
            if (type == 2)
            {
                cmd.Parameters.AddWithValue("@emp_apellido", emp_parameter);
            }
            else
            {
                cmd.Parameters.AddWithValue("@emp_apellido", System.Data.SqlTypes.SqlString.Null);
            }
            if (type == 3)
            {
                cmd.Parameters.AddWithValue("@emp_cedula", emp_parameter);
            }
            else
            {
                cmd.Parameters.AddWithValue("@emp_cedula", System.Data.SqlTypes.SqlString.Null);
            }
            if (type == 4)
            {
                cmd.Parameters.AddWithValue("@dept_id", emp_parameter);
            }
            else
            {
                cmd.Parameters.AddWithValue("@dept_id", System.Data.SqlTypes.SqlString.Null);
            }
            if (type == 5)
            {
                cmd.Parameters.AddWithValue("@emp_ext", emp_parameter);
            }
            else
            {
                cmd.Parameters.AddWithValue("@emp_ext", System.Data.SqlTypes.SqlString.Null);
            }
            if (type == 6)
            {
                cmd.Parameters.AddWithValue("@emp_flota", emp_parameter);
            }
            else
            {
                cmd.Parameters.AddWithValue("@emp_flota", System.Data.SqlTypes.SqlString.Null);
            }
            if (type == 7)
            {
                cmd.Parameters.AddWithValue("@emp_id", Convert.ToInt32(emp_parameter));
            }
            else
            {
                cmd.Parameters.AddWithValue("@emp_id", System.Data.SqlTypes.SqlInt32.Null);
            }

            if (type == 8)
            {
                SqlCommand cmd2 = new SqlCommand("spConsultaEmpleadoGeneral", cn);
                cmd2.CommandType = CommandType.StoredProcedure;
                cmd2.Parameters.AddWithValue("@parametro", emp_parameter);
                SqlDataAdapter SqlDa2 = new SqlDataAdapter(cmd2);
                SqlDa2.Fill(dsCliente);
                cn.Close();
                return(dsCliente.Tables[0]);
            }
            //Fin de multiples formas de consultar

            SqlDataAdapter SqlDa = new SqlDataAdapter(cmd);

            SqlDa.Fill(dsCliente);
            cn.Close();
            return(dsCliente.Tables[0]);
        }
Exemple #15
0
        public void editarEmpleado(int emp_id, string emp_nombre, string emp_apellido,
                                    string emp_cedula, string emp_extension, string emp_flota,
                                    int dept_id)
        {
            dbConnect ObjConexionDB = new dbConnect();
            SqlConnection cn = new SqlConnection(ObjConexionDB.connect());
            cn.Open();
            SqlCommand cmd = new SqlCommand("spActEmpleado", cn);
            cmd.CommandType = CommandType.StoredProcedure;

            if (String.IsNullOrEmpty(emp_nombre))
            {
                cmd.Parameters.AddWithValue("@emp_nombre", System.Data.SqlTypes.SqlString.Null);
            }

            else
            {
                cmd.Parameters.AddWithValue("@emp_nombre", emp_nombre);
            }

            if (String.IsNullOrEmpty(emp_apellido))
            {
                cmd.Parameters.AddWithValue("@emp_apellido", System.Data.SqlTypes.SqlString.Null);
            }
            else
            {
                cmd.Parameters.AddWithValue("@emp_apellido", emp_apellido);
            }

            if (String.IsNullOrEmpty(emp_cedula))
            {
                cmd.Parameters.AddWithValue("@emp_cedula", System.Data.SqlTypes.SqlString.Null);
            }
            else
            {
                cmd.Parameters.AddWithValue("@emp_cedula", emp_cedula);
            }

            if (String.IsNullOrEmpty(emp_extension))
            {
                cmd.Parameters.AddWithValue("@emp_ext", System.Data.SqlTypes.SqlString.Null);
            }
            else
            {
                cmd.Parameters.AddWithValue("@emp_ext", emp_extension);
            }

            if (String.IsNullOrEmpty(emp_flota))
            {
                cmd.Parameters.AddWithValue("@emp_flota", System.Data.SqlTypes.SqlString.Null);
            }
            else
            {
                  cmd.Parameters.AddWithValue("@emp_flota", emp_flota);
            }

            cmd.Parameters.AddWithValue("@dept_id", dept_id);
            cmd.Parameters.AddWithValue("@emp_id",emp_id);
            cmd.ExecuteNonQuery();

            //Fin de multiples formas de consultar

            SqlDataAdapter SqlDa = new SqlDataAdapter(cmd);
            cn.Close();
        }
Exemple #16
0
        public DataTable ConsultarEmpleado(string emp_parameter, int type)
        {
            dbConnect ObjConexionDB = new dbConnect();
            DataSet dsCliente = new DataSet();
            SqlConnection cn = new SqlConnection(ObjConexionDB.connect());
            cn.Open();
            SqlCommand cmd = new SqlCommand("spConsultaEmpleado", cn);
            cmd.CommandType = CommandType.StoredProcedure;
            //Condiciones para multiples formas de consulta
            if (type == 1)
            {
                cmd.Parameters.AddWithValue("@emp_nombre", emp_parameter);
            }
            else
            {
                cmd.Parameters.AddWithValue("@emp_nombre", System.Data.SqlTypes.SqlString.Null);
            }
            if (type == 2)
            {
                cmd.Parameters.AddWithValue("@emp_apellido", emp_parameter);
            }
            else
            {
                cmd.Parameters.AddWithValue("@emp_apellido", System.Data.SqlTypes.SqlString.Null);
            }
            if (type == 3)
            {
                cmd.Parameters.AddWithValue("@emp_cedula", emp_parameter);
            }
            else
            {
                cmd.Parameters.AddWithValue("@emp_cedula", System.Data.SqlTypes.SqlString.Null);
            }
            if (type == 4)
            {
                cmd.Parameters.AddWithValue("@dept_id", emp_parameter);
            }
            else
            {
                cmd.Parameters.AddWithValue("@dept_id", System.Data.SqlTypes.SqlString.Null);
            }
            if (type == 5)
            {
                cmd.Parameters.AddWithValue("@emp_ext", emp_parameter);
            }
            else
            {
                cmd.Parameters.AddWithValue("@emp_ext", System.Data.SqlTypes.SqlString.Null);
            }
            if (type == 6)
            {
                cmd.Parameters.AddWithValue("@emp_flota", emp_parameter);
            }
            else
            {
                cmd.Parameters.AddWithValue("@emp_flota", System.Data.SqlTypes.SqlString.Null);
            }
            if (type == 7)
            {
                cmd.Parameters.AddWithValue("@emp_id", Convert.ToInt32(emp_parameter));
            }
            else
            {
                cmd.Parameters.AddWithValue("@emp_id", System.Data.SqlTypes.SqlInt32.Null);
            }

            if (type == 8)
            {
                SqlCommand cmd2 = new SqlCommand("spConsultaEmpleadoGeneral", cn);
                cmd2.CommandType = CommandType.StoredProcedure;
                cmd2.Parameters.AddWithValue("@parametro", emp_parameter);
                SqlDataAdapter SqlDa2 = new SqlDataAdapter(cmd2);
                SqlDa2.Fill(dsCliente);
                cn.Close();
                return dsCliente.Tables[0];
            }
            //Fin de multiples formas de consultar

            SqlDataAdapter SqlDa = new SqlDataAdapter(cmd);
            SqlDa.Fill(dsCliente);
            cn.Close();
            return dsCliente.Tables[0];
        }
Exemple #17
0
 public void eliminarEmpleado(int emp_id)
 {
     dbConnect ObjConexionDB = new dbConnect();
     DataSet dsCliente = new DataSet();
     SqlConnection cn = new SqlConnection(ObjConexionDB.connect());
     cn.Open();
     SqlCommand cmd = new SqlCommand("spEliminarEmpleado", cn);
     cmd.CommandType = CommandType.StoredProcedure;
     cmd.Parameters.AddWithValue("@emp_id", emp_id);
     cmd.ExecuteNonQuery();
 }
Exemple #18
0
 public void crearEmpleado(string emp_nombre, string emp_apellido,
                             string emp_cedula, string emp_extension, string emp_flota,
                             int dept_id)
 {
     dbConnect ObjConexionDB = new dbConnect();
     DataSet dsCliente = new DataSet();
     SqlConnection cn = new SqlConnection(ObjConexionDB.connect());
     cn.Open();
     SqlCommand cmd = new SqlCommand("spNuevoEmpleado", cn);
     cmd.CommandType = CommandType.StoredProcedure;
     cmd.Parameters.AddWithValue("@emp_nombre", emp_nombre);
     cmd.Parameters.AddWithValue("@emp_apellido", emp_apellido);
     cmd.Parameters.AddWithValue("@emp_cedula", emp_cedula);
     cmd.Parameters.AddWithValue("@dept_id", dept_id);
     cmd.Parameters.AddWithValue("@emp_ext", emp_extension);
     cmd.Parameters.AddWithValue("@emp_flota", emp_flota);
     cmd.ExecuteNonQuery();
 }
Exemple #19
0
 protected void Page_Load(object sender, EventArgs e)
 {
     dbConnect cnStr = new dbConnect();
     TextBox1.Text = cnStr.connect();
 }