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();
}
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();
}
}
