public DataTable Buscar(DSalon Salon) { DataTable dtResultado = new DataTable("Salon"); SqlConnection sqlCon = new SqlConnection(); try { sqlCon.ConnectionString = Conexion.cn; SqlCommand sqlCmd = new SqlCommand(); sqlCmd.Connection = sqlCon; sqlCmd.CommandText = "sp_buscarSalon"; sqlCmd.CommandType = CommandType.StoredProcedure; SqlParameter ParTextoBuscar = new SqlParameter(); ParTextoBuscar.ParameterName = "@textoBuscar"; ParTextoBuscar.SqlDbType = SqlDbType.VarChar; ParTextoBuscar.Size = 50; ParTextoBuscar.Value = Salon.TextoBuscar; sqlCmd.Parameters.Add(ParTextoBuscar); SqlDataAdapter sqlDat = new SqlDataAdapter(sqlCmd); sqlDat.Fill(dtResultado); } catch (Exception ex) { dtResultado = null; } return(dtResultado); }
public string Insertar(DSalon Salon) { string rpta = ""; SqlConnection sqlCon = new SqlConnection(); try { sqlCon.ConnectionString = Conexion.cn; sqlCon.Open(); //Comandos SqlCommand sqlCmd = new SqlCommand(); sqlCmd.Connection = sqlCon; sqlCmd.CommandText = "sp_insertarSalon"; sqlCmd.CommandType = CommandType.StoredProcedure; SqlParameter ParIdSalon = new SqlParameter(); ParIdSalon.ParameterName = "@idSalon"; ParIdSalon.SqlDbType = SqlDbType.Int; ParIdSalon.Direction = ParameterDirection.Output; sqlCmd.Parameters.Add(ParIdSalon); SqlParameter ParNomSalon = new SqlParameter(); ParNomSalon.ParameterName = "@nomSalon"; ParNomSalon.SqlDbType = SqlDbType.VarChar; ParNomSalon.Size = 20; ParNomSalon.Value = Salon.Nombre; sqlCmd.Parameters.Add(ParNomSalon); SqlParameter ParEstSalon = new SqlParameter(); ParEstSalon.ParameterName = "@estSalon"; ParEstSalon.SqlDbType = SqlDbType.Char; ParEstSalon.Size = 1; ParEstSalon.Value = Salon.Estado; sqlCmd.Parameters.Add(ParEstSalon); rpta = sqlCmd.ExecuteNonQuery() == 1 ? "OK" : "No se ingresó el Registro"; } catch (Exception ex) { rpta = ex.Message; } finally { if (sqlCon.State == ConnectionState.Open) { sqlCon.Close(); } } return(rpta); }
public string Eliminar(DSalon Salon) { string rpta = ""; SqlConnection sqlCon = new SqlConnection(); try { sqlCon.ConnectionString = Conexion.cn; sqlCon.Open(); //Comandos SqlCommand sqlCmd = new SqlCommand(); sqlCmd.Connection = sqlCon; sqlCmd.CommandText = "sp_eliminarSalon"; sqlCmd.CommandType = CommandType.StoredProcedure; SqlParameter ParIdSalon = new SqlParameter(); ParIdSalon.ParameterName = "@idSalon"; ParIdSalon.SqlDbType = SqlDbType.Int; ParIdSalon.Value = Salon.IdSalon; sqlCmd.Parameters.Add(ParIdSalon); rpta = sqlCmd.ExecuteNonQuery() == 1 ? "OK" : "No se eliminó el Registro"; } catch (Exception ex) { rpta = ex.Message; } finally { if (sqlCon.State == ConnectionState.Open) { sqlCon.Close(); } } return(rpta); }