private void ButtonRemoveMaterial_Click(object sender, RoutedEventArgs e)
{
if (MaterialsDataGrid.SelectedItem != null)
{
if (MessageBox.Show("Do you want to remove this material?", "", MessageBoxButton.YesNo, MessageBoxImage.Warning, MessageBoxResult.No) == MessageBoxResult.Yes)
{
selRow = MaterialsDataGrid.SelectedIndex;
clsMateriales obj = new clsMateriales
{
Cod_material = dt_materiales.Rows[selRow].Field <int>(0)
};
obj.BorrarMaterial();
dt_materiales = obj.CargarMateriales();
dt_materiales.Columns[0].ColumnName = "MATERIAL CODE";
dt_materiales.Columns[1].ColumnName = "DESCRIPTION";
dt_materiales.Columns[2].ColumnName = "UNIT";
dt_materiales.Columns[3].ColumnName = "VALUE";
MaterialsDataGrid.ItemsSource = dt_materiales.DefaultView;
}
}
}
private void button1_Click(object sender, EventArgs e)
{
clsMateriales objeto = new clsMateriales();
objeto.Cod_material = 1;
objeto.Nombre_material = "Cable#2";
objeto.Precio_material = 1250;
label6.Text = ("El material creado es " + objeto.Nombre_material + " Cuesta " + objeto.Precio_material.ToString());
//Console.ReadLine();
}
public ManageResources()
{
InitializeComponent();
clsMateriales obj_m = new clsMateriales();
dt_materiales = obj_m.CargarMateriales();
dt_materiales.Columns[0].ColumnName = "MATERIAL CODE";
dt_materiales.Columns[1].ColumnName = "DESCRIPTION";
dt_materiales.Columns[2].ColumnName = "UNIT";
dt_materiales.Columns[3].ColumnName = "VALUE";
MaterialsDataGrid.ItemsSource = dt_materiales.DefaultView;
clsPrestaciones obj_p = new clsPrestaciones();
dt_prestaciones = obj_p.CargarPrestaciones();
dt_prestaciones.Columns[0].ColumnName = "SERVICE CODE";
dt_prestaciones.Columns[1].ColumnName = "DESCRIPTION";
dt_prestaciones.Columns[2].ColumnName = "UNIT";
dt_prestaciones.Columns[3].ColumnName = "VALUE";
ServicesDataGrid.ItemsSource = dt_prestaciones.DefaultView;
clsEquipos obj_e = new clsEquipos();
dt_equipos = obj_e.CargarEquipos();
dt_equipos.Columns[0].ColumnName = "SERIAL NUMBER";
dt_equipos.Columns[1].ColumnName = "DESCRIPTION";
dt_equipos.Columns[2].ColumnName = "UNIT";
dt_equipos.Columns[3].ColumnName = "VALUE";
EquipmentDataGrid.ItemsSource = dt_equipos.DefaultView;
clsHerramientas obj_h = new clsHerramientas();
dt_herramientas = obj_h.CargarHerramientas();
dt_herramientas.Columns[0].ColumnName = "TOOL CODE";
dt_herramientas.Columns[1].ColumnName = "DESCRIPTION";
dt_herramientas.Columns[2].ColumnName = "UNIT";
dt_herramientas.Columns[3].ColumnName = "VALUE";
ToolsDataGrid.ItemsSource = dt_herramientas.DefaultView;
}
private void ButtonSave_Click(object sender, RoutedEventArgs e)
{
if (edit == true)
{
if (description_TB.Text != "" && unit_TB.Text != "" && value_TB.Text != "")
{
if (description_TB.Text == edit_material.Descripcion_material && unit_TB.Text == edit_material.Unidad_material && value_TB.Text == edit_material.Precio_material.ToString())
{
MessageBox.Show("No changes have been made", "", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
if (MessageBox.Show("Do you want to save the changes?", "", MessageBoxButton.YesNo, MessageBoxImage.Question, MessageBoxResult.No) == MessageBoxResult.Yes)
{
edit_material.Descripcion_material = description_TB.Text;
edit_material.Unidad_material = unit_TB.Text;
edit_material.Precio_material = float.Parse(value_TB.Text);
edit_material.ActualizarMaterial();
this.Close();
}
}
}
else
{
MessageBox.Show("You must complete all the data!", "", MessageBoxButton.OK, MessageBoxImage.Exclamation);
}
}
else
{
if (description_TB.Text != "" && unit_TB.Text != "" && value_TB.Text != "")
{
if (MessageBox.Show("Do you want to add this material?", "", MessageBoxButton.YesNo, MessageBoxImage.Question, MessageBoxResult.No) == MessageBoxResult.Yes)
{
clsMateriales nuevo_material = new clsMateriales
{
Descripcion_material = description_TB.Text,
Unidad_material = unit_TB.Text,
Precio_material = float.Parse(value_TB.Text)
};
nuevo_material.AgregarMaterial();
this.Close();
}
}
else
{
MessageBox.Show("You must complete all the data!", "", MessageBoxButton.OK, MessageBoxImage.Exclamation);
}
}
}
private void ButtonAddMaterial_Click(object sender, RoutedEventArgs e)
{
this.edit = false;
MaterialWindow materialWindow = new MaterialWindow(edit, selRow);
materialWindow.ShowDialog();
clsMateriales obj = new clsMateriales();
dt_materiales = obj.CargarMateriales();
dt_materiales.Columns[0].ColumnName = "MATERIAL CODE";
dt_materiales.Columns[1].ColumnName = "DESCRIPTION";
dt_materiales.Columns[2].ColumnName = "UNIT";
dt_materiales.Columns[3].ColumnName = "VALUE";
MaterialsDataGrid.ItemsSource = dt_materiales.DefaultView;
}
private void Clone_Click(object sender, RoutedEventArgs e)
{
if (profile_CB.Text == "Overhead line")
{
description_TB.Text = "Overhead line";
unit_TB.Text = "m";
quantity_TB.Text = "5";
clsMateriales clon_mat = new clsMateriales();
dt_mat_unit = clon_mat.ClonarMateriales();
dt_mat_unit.Columns[0].ColumnName = "MATERIAL CODE";
dt_mat_unit.Columns[1].ColumnName = "DESCRIPTION";
dt_mat_unit.Columns[2].ColumnName = "UNIT";
dt_mat_unit.Columns[3].ColumnName = "VALUE";
dt_mat_unit.Columns.Add("QUANTITY", typeof(int));
dt_mat_unit.Columns.Add("TOTAL", typeof(float));
dt_mat_unit.Rows[0][4] = 5;
dt_mat_unit.Rows[0][5] = 5 * (float)dt_mat_unit.Rows[0].Field <double>(3);
UnitMaterialsDataGrid.ItemsSource = dt_mat_unit.DefaultView;
clsPrestaciones clon_pre = new clsPrestaciones();
dt_pre_unit = clon_pre.ClonarPrestaciones();
dt_pre_unit.Columns[0].ColumnName = "SERVICE CODE";
dt_pre_unit.Columns[1].ColumnName = "DESCRIPTION";
dt_pre_unit.Columns[2].ColumnName = "UNIT";
dt_pre_unit.Columns[3].ColumnName = "VALUE";
dt_pre_unit.Columns.Add("QUANTITY", typeof(int));
dt_pre_unit.Columns.Add("TOTAL", typeof(float));
dt_pre_unit.Rows[0][4] = 1;
dt_pre_unit.Rows[0][5] = 1 * (float)dt_pre_unit.Rows[0].Field <double>(3);
UnitServicesDataGrid.ItemsSource = dt_pre_unit.DefaultView;
suma = (float)dt_mat_unit.Compute("sum(TOTAL)", "") + (float)dt_pre_unit.Compute("sum(TOTAL)", "");
value_TB.Text = suma.ToString();
}
}
private void ButtonEditMaterial_Click(object sender, RoutedEventArgs e)
{
if (MaterialsDataGrid.SelectedItem != null)
{
edit = true;
selRow = MaterialsDataGrid.SelectedIndex;
MaterialWindow materialWindow = new MaterialWindow(edit, selRow);
materialWindow.ShowDialog();
clsMateriales obj = new clsMateriales();
dt_materiales = obj.CargarMateriales();
dt_materiales.Columns[0].ColumnName = "MATERIAL CODE";
dt_materiales.Columns[1].ColumnName = "DESCRIPTION";
dt_materiales.Columns[2].ColumnName = "UNIT";
dt_materiales.Columns[3].ColumnName = "VALUE";
MaterialsDataGrid.ItemsSource = dt_materiales.DefaultView;
}
}
public MaterialWindow(bool ed, int selr)
{
InitializeComponent();
this.edit = ed;
this.selRow = selr;
if (edit == true)
{
clsMateriales obj = new clsMateriales();
dt = obj.CargarMateriales();
this.edit_material.Cod_material = dt.Rows[selRow].Field <int>(0);
this.edit_material.Descripcion_material = dt.Rows[selRow].Field <string>(1);
this.edit_material.Unidad_material = dt.Rows[selRow].Field <string>(2);
this.edit_material.Precio_material = (float)dt.Rows[selRow].Field <double>(3);
description_TB.Text = edit_material.Descripcion_material;
unit_TB.Text = edit_material.Unidad_material;
value_TB.Text = edit_material.Precio_material.ToString();
titleLabel.Content = "Edit material";
}
}
public UnitWindow(bool ed, int selr, int id_c)
{
InitializeComponent();
this.edit = ed;
this.selRow = selr;
this.index_capitulo = id_c;
clsMateriales obj_m = new clsMateriales();
dt_materiales = obj_m.CargarMateriales();
dt_materiales.Columns[0].ColumnName = "MATERIAL CODE";
dt_materiales.Columns[1].ColumnName = "DESCRIPTION";
dt_materiales.Columns[2].ColumnName = "UNIT";
dt_materiales.Columns[3].ColumnName = "VALUE";
MaterialsDataGrid.ItemsSource = dt_materiales.DefaultView;
dt_mat_unit.Columns.Add("MATERIAL CODE", typeof(int));
dt_mat_unit.Columns.Add("DESCRIPTION", typeof(string));
dt_mat_unit.Columns.Add("UNIT", typeof(string));
dt_mat_unit.Columns.Add("VALUE", typeof(float));
dt_mat_unit.Columns.Add("QUANTITY", typeof(int));
dt_mat_unit.Columns.Add("TOTAL", typeof(float));
UnitMaterialsDataGrid.ItemsSource = dt_mat_unit.DefaultView;
clsPrestaciones obj_p = new clsPrestaciones();
dt_prestaciones = obj_p.CargarPrestaciones();
dt_prestaciones.Columns[0].ColumnName = "SERVICE CODE";
dt_prestaciones.Columns[1].ColumnName = "DESCRIPTION";
dt_prestaciones.Columns[2].ColumnName = "UNIT";
dt_prestaciones.Columns[3].ColumnName = "VALUE";
ServicesDataGrid.ItemsSource = dt_prestaciones.DefaultView;
dt_pre_unit.Columns.Add("SERVICE CODE", typeof(int));
dt_pre_unit.Columns.Add("DESCRIPTION", typeof(string));
dt_pre_unit.Columns.Add("UNIT", typeof(string));
dt_pre_unit.Columns.Add("VALUE", typeof(float));
dt_pre_unit.Columns.Add("QUANTITY", typeof(int));
dt_pre_unit.Columns.Add("TOTAL", typeof(float));
UnitServicesDataGrid.ItemsSource = dt_pre_unit.DefaultView;
clsEquipos obj_e = new clsEquipos();
dt_equipos = obj_e.CargarEquipos();
dt_equipos.Columns[0].ColumnName = "SERIAL NUMBER";
dt_equipos.Columns[1].ColumnName = "DESCRIPTION";
dt_equipos.Columns[2].ColumnName = "UNIT";
dt_equipos.Columns[3].ColumnName = "VALUE";
EquipmentDataGrid.ItemsSource = dt_equipos.DefaultView;
dt_equ_unit.Columns.Add("SERIAL NUMBER", typeof(int));
dt_equ_unit.Columns.Add("DESCRIPTION", typeof(string));
dt_equ_unit.Columns.Add("UNIT", typeof(string));
dt_equ_unit.Columns.Add("VALUE", typeof(float));
dt_equ_unit.Columns.Add("QUANTITY", typeof(int));
dt_equ_unit.Columns.Add("TOTAL", typeof(float));
UnitEquipmentDataGrid.ItemsSource = dt_equ_unit.DefaultView;
clsHerramientas obj_h = new clsHerramientas();
dt_herramientas = obj_h.CargarHerramientas();
dt_herramientas.Columns[0].ColumnName = "TOOL CODE";
dt_herramientas.Columns[1].ColumnName = "DESCRIPTION";
dt_herramientas.Columns[2].ColumnName = "UNIT";
dt_herramientas.Columns[3].ColumnName = "VALUE";
ToolsDataGrid.ItemsSource = dt_herramientas.DefaultView;
dt_her_unit.Columns.Add("TOOL CODE", typeof(int));
dt_her_unit.Columns.Add("DESCRIPTION", typeof(string));
dt_her_unit.Columns.Add("UNIT", typeof(string));
dt_her_unit.Columns.Add("VALUE", typeof(float));
dt_her_unit.Columns.Add("QUANTITY", typeof(int));
dt_her_unit.Columns.Add("TOTAL", typeof(float));
UnitToolsDataGrid.ItemsSource = dt_her_unit.DefaultView;
}
