} //Clave de Método: Moves-MLM
private void ControlClickMethod(object sender, EventArgs e)
{
try
{
for (; Index < ArrayControl.Length; Index++)
{
if (ArrayControl[Index] == sender)
{
break;
}
}
switch (Index)
{
case 0: // ButtonSearch
{
if (TextBoxSearch.Visible)
{
if (ObjValidations.NumControlCheck(TextBoxSearch.TextTextBox.Trim()))
{
ObjSearch.NumControl = TextBoxSearch.TextTextBox.Trim();
}
else
{
throw new FormatException();
}
}
else
{
ObjSearch.NumControl = string.Empty;
}
if (RadioButtonAllDepartments.Checked || (!RadioButtonAllDepartments.Checked && !RadioButtonSearchDepartment.Checked) || !GroupBoxDepartment.Visible)
{
ObjSearch.IndexDeparmentStart = 0;
ObjSearch.IndexDeparmentEnd = 30;
}
else
{
ObjSearch.IndexDeparmentStart = ComboTypeDepartment.SelectedIndex;
ObjSearch.IndexDeparmentEnd = ComboTypeDepartment.SelectedIndex;
}
if (RadioButtonBothSex.Checked || (!RadioButtonBothSex.Checked && !RadioButtonMan.Checked && !RadioButtonWoman.Checked) || !GroupBoxSex.Visible)
{
ObjSearch.SexStart = 'M';
ObjSearch.SexEnd = 'F';
}
else if (RadioButtonMan.Checked)
{
ObjSearch.SexStart = 'M';
ObjSearch.SexEnd = 'M';
}
else
{
ObjSearch.SexStart = 'F';
ObjSearch.SexEnd = 'F';
}
if (PanelDate.Visible)
{
ObjSearch.DateStart = DateTimePickerStart.Value;
ObjSearch.DateEnd = DateTimePickerEnd.Value;
}
else
{
DateTimePickerStart.Value = DateTime.Parse("2000-01-01");
ObjSearch.DateEnd = DateTimePickerEnd.Value;
}
ObjValidations.SearchMoves(TypeModules.Moves, ObjSearch);
PopUpGridSearch ObjPopUpGridSearch = new PopUpGridSearch(TypeModules.Moves, ObjSearch, "Búsqueda de Movimientos");
ObjPopUpGridSearch.Show();
break;
}
case 1: // ButtonSearchAll
{
ObjSearch.NumControl = "";
ObjSearch.IndexDeparmentStart = 0;
ObjSearch.IndexDeparmentEnd = 30;
ObjSearch.SexStart = 'F';
ObjSearch.SexEnd = 'M';
DateTimePickerStart.Value = DateTime.Parse("2000-01-01");
ObjSearch.DateEnd = DateTimePickerEnd.Value;
ObjValidations.SearchMoves(TypeModules.Moves, ObjSearch);
PopUpGridSearch ObjPopUpGridSearch = new PopUpGridSearch(TypeModules.Moves, ObjSearch, "Búsqueda de Movimientos");
ObjPopUpGridSearch.Show();
break;
}
case 2: //ButtonCleanSearch
{
RadioButtonBothSex.Checked = false;
RadioButtonMan.Checked = false;
RadioButtonWoman.Checked = false;
RadioButtonAllDepartments.Checked = false;
RadioButtonSearchDepartment.Checked = false;
ComboTypeDepartment.Visible = false;
DateTimePickerStart.Value = DateTime.Now.AddMonths(-1);
DateTimePickerEnd.Value = DateTime.Now;
break;
}
default:
throw new Exception("Excepción en Método: Moves-CCM", new IndexOutOfRangeException());
}
}
catch (IndexOutOfRangeException)
{
}
catch (FormatException)
{
using (Alerts ObjAlerts = new Alerts("Número de Control Invalido", "", "El número de control ingresado no es valido\n\nVereifique el texto que ingresó.", 1, "", "", "OK", TypeIcon.Warning))
{
if (ObjAlerts.ShowDialog() == DialogResult.OK)
{
ObjAlerts.Close();
ObjAlerts.Dispose();
}
}
}
Index = 0;
} //Clave de Método: Moves-CCM
} //Clave de Método: Stats-CIM
private void ControlClickMethod(object sender, EventArgs e)
{
for (; Index < ArrayControl.Length; Index++)
{
if (ArrayControl[Index] == sender)
{
break;
}
}
switch (Index)
{
case 0: //ButtonCreateReport
{
byte i = 0;
byte aux = 0;
try
{
foreach (RadioButton Value in ArrayRadioDate)
{
if (!Value.Checked)
{
i++;
}
else
{
aux = i;
}
}
if (i == 6)
{
throw new Exception();
}
switch (aux)
{
case 0:
{
ObjSearch.DateStart = DateTime.Now;
ObjSearch.DateEnd = DateTime.Now;
break;
}
case 1:
{
ObjSearch.DateStart = DateTime.Now.AddDays(-7);
ObjSearch.DateEnd = DateTime.Now;
break;
}
case 2:
{
ObjSearch.DateStart = DateTime.Now.AddMonths(-1);
ObjSearch.DateEnd = DateTime.Now;
break;
}
case 3:
{
ObjSearch.DateStart = DateTime.Now.AddYears(-1);
ObjSearch.DateEnd = DateTime.Now;
break;
}
case 4:
{
ObjSearch.DateStart = DateTime.Parse("2000-01-01");
ObjSearch.DateEnd = DateTime.Now;
break;
}
case 5:
{
ObjSearch.DateStart = DateTimePickerStart.Value;
ObjSearch.DateEnd = DateTimePickerEnd.Value;
break;
}
default:
throw new Exception();
}
i = 0;
foreach (CheckBox Value in ArrayCheckBox)
{
if (!Value.Checked)
{
i++;
}
}
if (i == 7)
{
throw new Exception();
}
if (RadioButtonBothSex.Checked || (!RadioButtonBothSex.Checked && !RadioButtonMan.Checked && !RadioButtonWoman.Checked))
{
ObjSearch.SexStart = 'M';
ObjSearch.SexEnd = 'F';
}
else if (RadioButtonMan.Checked)
{
ObjSearch.SexStart = 'M';
ObjSearch.SexEnd = 'M';
}
else
{
ObjSearch.SexStart = 'F';
ObjSearch.SexEnd = 'F';
}
i = 1;
foreach (CheckBox Value in ArrayCheckBox)
{
if (Value.Checked)
{
ObjSearch.Services.Add(i);
}
else
{
ObjSearch.Services.Add(0);
}
i++;
}
if (ComboDepartmentCareer.SelectedIndex == 0)
{
ObjSearch.IndexDeparmentStart = 0;
ObjSearch.IndexDeparmentEnd = 30;
}
else
{
ObjSearch.IndexDeparmentStart = ComboDepartmentCareer.SelectedIndex;
ObjSearch.IndexDeparmentEnd = ComboDepartmentCareer.SelectedIndex;
}
ObjValidations.SearchStats(TypeModules.Stats, ObjSearch);
PopUpGridSearch ObjPopUpGridSearch = new PopUpGridSearch(TypeModules.Moves, ObjSearch, "Búsqueda para Reportes");
ObjPopUpGridSearch.Show();
}
catch (Exception)
{
Alerts ObjAlerts = new Alerts("Falta Elegir Opciones", "", "Parece ser que no elegiste ningún tipo de servicio o ningún tipo de fecha. Estos datos son necesarios para generar el reporte.\n\nPor favor, elige algún servicio y alguna fecha para continuar.", 1);
ObjAlerts.ShowDialog();
}
finally
{
i = 0;
ObjSearch.Services.Clear();
}
break;
}
case 1: //ButtonCancel
{
CleanInputsMethod();
break;
}
case 2: //PictureBoxInfo
{
break;
}
default:
throw new Exception("Excepción en Método: Stats-CCM", new IndexOutOfRangeException());
}
Index = 0;
} //Clave de Método: Stats-CCM
public void ControlClickMethod(object sender, EventArgs e)
{
for (; Index < ArrayControl.Length; Index++)
{
if (ArrayControl[Index] == sender)
{
break;
}
}
switch (Index)
{
case 0: //ButtonExamine
{
using (OpenFileDialog ObjFile = new OpenFileDialog())
{
ObjFile.Title = "Archivo CSV para importación de usuarios";
ObjFile.Filter = "CSV Files (*.csv) | *.csv";
ObjFile.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
ObjDialog = ObjFile.ShowDialog();
if (ObjDialog == DialogResult.OK)
{
string[] ArrayLinea;
int x = 0;
try
{
string[] Lineas = File.ReadAllLines(ObjFile.FileName);
ObjSearch.Table.Rows.Clear();
GridSearch.DataSource = null;
if (GridSearch.Columns.Count > 0)
{
GridSearch.Columns.Clear();
}
if (GridSearch.Rows.Count > 0)
{
GridSearch.Rows.Clear();
}
foreach (string linea in Lineas)
{
x++;
DataRow Fila = ObjSearch.Table.NewRow();
string temp = ObjValidations.RemoveAccent(linea.ToUpper());
temp = ObjValidations.CleanLineaImport(temp);
ArrayLinea = temp.Split(',');
Fila["NUMERO DE CONTROL"] = ArrayLinea[0];
Fila["NOMBRES"] = ArrayLinea[1];
Fila["APELLIDO PATERNO"] = ArrayLinea[2];
Fila["APELLIDO MATERNO"] = ArrayLinea[3];
Fila["DEPARTAMENTO O CARRERA"] = ArrayLinea[4];
Fila["SEXO"] = (ArrayLinea[5] == "M" || ArrayLinea[5] == "HOMBRE" || ArrayLinea[5] == "MASCULINO") ? "M" : "F";
Fila["STATUS"] = (ArrayLinea[6] == "A" || ArrayLinea[6] == "I" || ArrayLinea[6] == "ACTIVO" || ArrayLinea[6] == "ACT" || ArrayLinea[6] != "EGR" || ArrayLinea[6] != "EGRESADO") ? "A" : "I";
ObjSearch.Table.Rows.Add(Fila);
}
GridSearch.DataSource = ObjSearch.Table;
DataGridViewButtonColumn ObjButtonColumnEdit = new DataGridViewButtonColumn();
{
ObjButtonColumnEdit.Name = "EDITAR";
ObjButtonColumnEdit.HeaderText = "EDITAR";
ObjButtonColumnEdit.Text = "EDITAR";
ObjButtonColumnEdit.FlatStyle = FlatStyle.Flat;
ObjButtonColumnEdit.UseColumnTextForButtonValue = true;
GridSearch.Columns.Add(ObjButtonColumnEdit);
}
GridSearch.CellClick += GridSearchCellClickMethod;
GridSearch.Columns["EDITAR"].DisplayIndex = GridSearch.Columns.Count - 1;
}
catch (Exception Error)
{
MessageBox.Show("Error: " + Error.ToString());
}
}
}
if (GridSearch.Rows.Count > 0)
{
LabelTotal.Text = GridSearch.Rows.Count.ToString();
ButtonImportTable.Enabled = true;
}
else
{
LabelTotal.Text = "0";
ButtonImportTable.Enabled = false;
}
break;
}
case 1: //ButtonImportTable
{
if (GridSearch.Rows.Count > 0)
{
using (Alerts ObjAlerts = new Alerts("Confirmación de Importación", "", "Usted está por realizar una importación de usuarios. La cantidad de usuarios a importar es de: " + GridSearch.Rows.Count.ToString() + "\n\n¿Está seguro de importar esta cantidad?", 1, "", "", "OK", TypeIcon.Warning))
{
if (ObjAlerts.ShowDialog() == DialogResult.OK)
{
DataTable TablaAuxiliar;
TablaAuxiliar = ObjSearch.Table.Copy();
TablaAuxiliar.Rows.Clear();
DataColumn ColumnaError = new DataColumn("RESULTADO DE OPERACION", typeof(string))
{
Caption = "RESULTADO DE OPERACION", ReadOnly = false, AutoIncrement = false, AllowDBNull = false
};
TablaAuxiliar.Columns.Add(ColumnaError);
int Contador = 0;
ProgressBarImport.Value = 0;
ProgressBarImport.Maximum = GridSearch.Rows.Count;
PanelLoad.Visible = true;
foreach (DataRow FilaTabla in ObjSearch.Table.Rows)
{
ObjModifyUsers.NumControl = FilaTabla["NUMERO DE CONTROL"].ToString().Trim();
if (FilaTabla["NOMBRES"].ToString().Contains(" "))
{
ObjModifyUsers.FirstName = FilaTabla["NOMBRES"].ToString().Split(' ')[0].Trim();
ObjModifyUsers.SecondName = FilaTabla["NOMBRES"].ToString().Split(' ')[1].Trim();
}
else
{
ObjModifyUsers.FirstName = FilaTabla["NOMBRES"].ToString().Trim();
ObjModifyUsers.SecondName = string.Empty;
}
ObjModifyUsers.FirstLastName = (string.IsNullOrEmpty(FilaTabla["APELLIDO PATERNO"].ToString().Trim())) ? string.Empty : FilaTabla["APELLIDO PATERNO"].ToString();
ObjModifyUsers.SecondLastName = (string.IsNullOrEmpty(FilaTabla["APELLIDO MATERNO"].ToString().Trim())) ? string.Empty : FilaTabla["APELLIDO MATERNO"].ToString();
ObjModifyUsers.IndexDeparment = Convert.ToByte(FilaTabla["DEPARTAMENTO O CARRERA"].ToString());
ObjModifyUsers.Status = Convert.ToChar(FilaTabla["STATUS"].ToString());
ObjModifyUsers.Sex = Convert.ToChar(FilaTabla["SEXO"].ToString());
DataRow FilaAuxiliar = TablaAuxiliar.NewRow();
FilaAuxiliar["NUMERO DE CONTROL"] = FilaTabla["NUMERO DE CONTROL"];
FilaAuxiliar["NOMBRES"] = FilaTabla["NOMBRES"];
FilaAuxiliar["APELLIDO PATERNO"] = FilaTabla["APELLIDO PATERNO"];
FilaAuxiliar["APELLIDO MATERNO"] = FilaTabla["APELLIDO MATERNO"];
FilaAuxiliar["DEPARTAMENTO O CARRERA"] = FilaTabla["DEPARTAMENTO O CARRERA"];
FilaAuxiliar["SEXO"] = FilaTabla["SEXO"];
FilaAuxiliar["STATUS"] = FilaTabla["STATUS"];
switch (ObjValidations.AddUser(TypeModules.Users, ObjModifyUsers))
{
case Result.Correct:
{
FilaAuxiliar["RESULTADO DE OPERACION"] = "Registro importado correctamente.";
Contador++;
break;
}
case Result.Duplicate:
{
FilaAuxiliar["RESULTADO DE OPERACION"] = "Ya existe este registro en la base de datos.";
break;
}
case Result.Invalid:
{
FilaAuxiliar["RESULTADO DE OPERACION"] = "El número de control no tiene el formato correcto.";
break;
}
case Result.NullNames:
{
FilaAuxiliar["RESULTADO DE OPERACION"] = "No existen nombres para este usuario.";
break;
}
case Result.NullLastNames:
{
FilaAuxiliar["RESULTADO DE OPERACION"] = "No existen apellidos para este usuario.";
break;
}
default:
{
FilaAuxiliar["RESULTADO DE OPERACION"] = "El origen del error es desconocido...";
break;
}
}
TablaAuxiliar.Rows.Add(FilaAuxiliar);
ProgressBarImport.PerformStep();
}
LabelCantidadFilas.Text = +Contador + " de " + GridSearch.Rows.Count;
LabelFinish.Visible = true;
GridSearch.DataSource = null;
if (GridSearch.Columns.Count > 0)
{
GridSearch.Columns.Clear();
}
if (GridSearch.Rows.Count > 0)
{
GridSearch.Rows.Clear();
}
GridSearch.DataSource = TablaAuxiliar;
}
}
}
break;
}
case 2: //ButtonRedo
{
RedoInterface();
break;
}
default:
throw new Exception("Excepción en Método: Imports-CCM");
}
Index = 0;
} //Clave de Método: Imports-CCM
} //Clave de Método: Users-SIVM
private void ControlClickMethod(object sender, EventArgs e)
{
for (; Index < ArrayControl.Length; Index++)
{
if (ArrayControl[Index] == sender)
{
break;
}
}
switch (Index)
{
case 0: //ButtonNewUser
{
PopUpUsers ObjPopUpUsers = new PopUpUsers();
ObjPopUpUsers.Show();
break;
}
case 1: //PictureBoxInfo
{
break;
}
case 2: //ButtonCleanSearch
{
GridSearch.DataSource = ObjValidations.GridSearchMethod(TypeModules.Users, TypeSearch.Users);
LabelTotalResults.Text = GridSearch.Rows.Count.ToString();
TextBoxSearch.TextTextBox = string.Empty;
GridSearch.Columns["EDITAR"].DisplayIndex = GridSearch.Columns.Count - 1;
break;
}
case 3: //ButtonSearch
{
bool Flag = false;
try
{
switch (ComboTypeSearch.SelectedIndex)
{
case 0:
case 1:
case 2:
case 3:
case 4:
{
Flag = !string.IsNullOrEmpty(TextBoxSearch.TextTextBox) ? true : false;
break;
}
case 5:
case 7:
{
Flag = RadioButtonOption1.Checked || RadioButtonOption2.Checked ? true : false;
break;
}
case 6:
{
Flag = ComboTypeDepartment.SelectedIndex > -1 ? true : false;
break;
}
}
if (Flag)
{
GridSearch.DataSource = ObjValidations.SearchUser(TypeModules.Users,
(byte)ComboTypeSearch.SelectedIndex,
TextBoxSearch.TextTextBox.Trim().ToUpper(),
RadioButtonOption1.Checked ? 'M' : 'F',
(byte)ComboTypeDepartment.SelectedIndex,
RadioButtonOption1.Checked ? 'A' : 'I');
GridSearch.Columns["EDITAR"].DisplayIndex = GridSearch.Columns.Count - 1;
}
else
{
throw new Exception();
}
}
catch (Exception)
{
using (Alerts ObjAlerts = new Alerts("Búsqueda Fallida", "", "Parece que ser que la búsqueda no se pudo completar.\nPor favor, revise los siguientes puntos:\n1. Es necesario que eliga un filtro de búsqueda."
+ "\n2. Ingrese un texto a buscar o seleccione una opción de búsqueda..\n3. Haga clic en el botón de búsqueda (lupa).", 1, "", "", "OK", TypeIcon.Warning))
{
if (ObjAlerts.ShowDialog() == DialogResult.OK)
{
ObjAlerts.Close();
ObjAlerts.Dispose();
}
}
}
break;
}
default:
throw new Exception("Excepción en Método: Users-CCM", new IndexOutOfRangeException());
}
Index = 0;
} //Clave de Método: Users-CCM
