public string AgregarArea(T_C_Area area) { try { Connection = new SqlConnection(ConnectionString); using (Command = new System.Data.SqlClient.SqlCommand("T_C_AreaInsert", Connection)) { Command.CommandType = System.Data.CommandType.StoredProcedure; Command.Parameters.AddWithValue("@Id_Area", area.Id_Area); Command.Parameters.AddWithValue("@Descripcion", area.Descripcion); Command.Parameters.AddWithValue("@Nombre", area.Nombre); Connection.Open(); Command.ExecuteNonQuery(); } return "Registro grabado satisfactoriamente."; } catch (Exception ex) { return ex.Message; } finally { Connection.Close(); } }
public T_C_Area SeleccionarArea(string idArea) { try { T_C_Area area; using (Command = new System.Data.SqlClient.SqlCommand("T_C_AreaSelect", Connection)) { Command.CommandType = System.Data.CommandType.StoredProcedure; Command.Parameters.AddWithValue("@Id_Area", idArea); Connection.Open(); SqlDataReader reader = Command.ExecuteReader(); area = new T_C_Area(); while (reader.Read()) { area.Id_Area = reader.GetValue(reader.GetOrdinal("Id_Area")).ToString(); area.Nombre = reader.GetValue(reader.GetOrdinal("Nombre")).ToString(); area.Descripcion = reader.GetValue(reader.GetOrdinal("Descripcion")).ToString(); area.Id_Estado = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("Id_Estado")).ToString()); area.Estado = estadoAccess.Seleccionar(area.Id_Estado); } } return(area); } catch (Exception ex) { return(null); } finally { Connection.Close(); } }
public List <T_C_Area> SeleccionarTodosArea() { try { List <T_C_Area> areas; using (Command = new System.Data.SqlClient.SqlCommand("T_C_AreaSelectAll", Connection)) { Command.CommandType = System.Data.CommandType.StoredProcedure; Connection.Open(); areas = new List <T_C_Area>(); SqlDataReader reader = Command.ExecuteReader(); while (reader.Read()) { T_C_Area area = new T_C_Area(); area.Id_Area = reader.GetValue(reader.GetOrdinal("Id_Area")).ToString(); area.Nombre = reader.GetValue(reader.GetOrdinal("Nombre")).ToString(); area.Descripcion = reader.GetValue(reader.GetOrdinal("Descripcion")).ToString(); area.Id_Estado = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("Id_Estado")).ToString()); area.Estado = estadoAccess.Seleccionar(area.Id_Estado); areas.Add(area); } } return(areas); } catch (Exception ex) { return(null); } finally { Connection.Close(); } }
public string ActualizarArea(T_C_Area area) { try { using (Command = new System.Data.SqlClient.SqlCommand("T_C_AreaUpdate", Connection)) { Command.CommandType = System.Data.CommandType.StoredProcedure; Command.Parameters.AddWithValue("@Id_Area", area.Id_Area); Command.Parameters.AddWithValue("@Nombre", area.Nombre); Command.Parameters.AddWithValue("@Descripcion", area.Descripcion); Command.Parameters.AddWithValue("@Id_Estado", area.Id_Estado); Connection.Open(); Command.ExecuteNonQuery(); } return("Registro actualizado satisfactoriamente."); } catch (Exception ex) { return(ex.Message); } finally { Connection.Close(); } }
private void btnRegistrar_Click(object sender, RoutedEventArgs e) { T_C_Area area = new T_C_Area(); area.Id_Area = txtIdArea.Text; area.Nombre = txtNombre.Text; area.Descripcion = txtDescripción.Text; MessageBox.Show(areaLogic.AgregarArea(area)); gvAreas.ItemsSource = areaLogic.ListarAreas(); Limpiar(); }
private void btnEliminar_Click(object sender, RoutedEventArgs e) { T_C_Area area = new T_C_Area(); area.Id_Area = txtIdArea.Text; area.Nombre = txtNombre.Text; area.Descripcion = txtDescripción.Text; area.Id_Estado = (cmbEstado.SelectedItem as T_C_Estado).Id_Estado; MessageBox.Show(areaLogic.EliminarArea(area)); gvAreas.ItemsSource = areaLogic.ListarAreas(); Limpiar(); }
public string EliminarArea(T_C_Area area) { try { using (Command = new System.Data.SqlClient.SqlCommand("T_C_AreaDelete", Connection)) { Command.CommandType = System.Data.CommandType.StoredProcedure; Command.Parameters.AddWithValue("@Id_Area", area.Id_Area); Connection.Open(); Command.ExecuteNonQuery(); } return("Registro eliminado satisfactoriamente."); } catch (Exception ex) { return(ex.Message); } finally { Connection.Close(); } }
private void gvAreas_SelectionChanged(object sender, Telerik.Windows.Controls.SelectionChangeEventArgs e) { if (gvAreas.SelectedItem != null) { btnRegistrar.IsEnabled = false; btnActualizar.IsEnabled = true; btnEliminar.IsEnabled = true; btnLimpiar.IsEnabled = true; lblEstado.Visibility = Visibility.Visible; cmbEstado.Visibility = Visibility.Visible; T_C_Area temp = gvAreas.SelectedItem as T_C_Area; txtDescripción.Text = temp.Descripcion; txtIdArea.Text = temp.Id_Area; txtNombre.Text = temp.Nombre; for (int i = 0; i <= cmbEstado.Items.Count; i++) { if ((cmbEstado.Items[i] as T_C_Estado).Id_Estado == temp.Id_Estado) { cmbEstado.SelectedIndex = i; break; } } } }
public string EliminarArea(T_C_Area area) { return areaAccess.EliminarArea(area); }
public string ActualizarArea(T_C_Area area) { return areaAccess.ActualizarArea(area); }
public string AgregarArea(T_C_Area area) { return areaAccess.AgregarArea(area); }
public string EliminarArea(T_C_Area area) { return(areaAccess.EliminarArea(area)); }
public string ActualizarArea(T_C_Area area) { return(areaAccess.ActualizarArea(area)); }
public string AgregarArea(T_C_Area area) { return(areaAccess.AgregarArea(area)); }
public T_C_Area SeleccionarArea(string idArea) { try { Connection = new SqlConnection(ConnectionString); T_C_Area area; using (Command = new System.Data.SqlClient.SqlCommand("T_C_AreaSelect", Connection)) { Command.CommandType = System.Data.CommandType.StoredProcedure; Command.Parameters.AddWithValue("@Id_Area", idArea); Connection.Open(); SqlDataReader reader = Command.ExecuteReader(); area = new T_C_Area(); while (reader.Read()) { area.Id_Area = reader.GetValue(reader.GetOrdinal("Id_Area")).ToString(); area.Nombre = reader.GetValue(reader.GetOrdinal("Nombre")).ToString(); area.Descripcion = reader.GetValue(reader.GetOrdinal("Descripcion")).ToString(); area.Id_Estado = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("Id_Estado")).ToString()); area.Estado = estadoAccess.Seleccionar(area.Id_Estado); } } return area; } catch (Exception ex) { return null; } finally { Connection.Close(); } }
public List<T_C_Area> SeleccionarTodosArea() { try { Connection = new SqlConnection(ConnectionString); List<T_C_Area> areas; using (Command = new System.Data.SqlClient.SqlCommand("T_C_AreaSelectAll", Connection)) { Command.CommandType = System.Data.CommandType.StoredProcedure; Connection.Open(); areas = new List<T_C_Area>(); SqlDataReader reader = Command.ExecuteReader(); while (reader.Read()) { T_C_Area area = new T_C_Area(); area.Id_Area = reader.GetValue(reader.GetOrdinal("Id_Area")).ToString(); area.Nombre = reader.GetValue(reader.GetOrdinal("Nombre")).ToString(); area.Descripcion = reader.GetValue(reader.GetOrdinal("Descripcion")).ToString(); area.Id_Estado = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("Id_Estado")).ToString()); area.Estado = estadoAccess.Seleccionar(area.Id_Estado); areas.Add(area); } } return areas; } catch (Exception ex) { return null; } finally { Connection.Close(); } }