private void btnGuardar_Click(object sender, EventArgs e)
{
try
{
if (lblId.Text != "")
{
Profesionales prof = new Profesionales(Convert.ToInt32(lblId.Text), "", "", null, "", "", "", 0,0,0);
string ingreso = txtIng.Text;
string egreso = txtEgr.Text;
DateTime t;
DateTime t1;
txtDesde.ValidatingType = typeof(System.DateTime);
txtDesde.TypeValidationCompleted += new TypeValidationEventHandler(txtDesde_TypeValidationCompleted);
txtHasta.ValidatingType = typeof(System.DateTime);
txtHasta.TypeValidationCompleted += new TypeValidationEventHandler(txtHasta_TypeValidationCompleted);
string lunes = "0";
string martes = "0";
string miercoles = "0";
string jueves = "0";
string viernes = "0";
string sabado = "0";
string domingo = "0";
int i;
for (i = 0; i <= (checkedListBox1.Items.Count - 1); i++)
{
if (checkedListBox1.GetItemChecked(i))
{
if (checkedListBox1.Items[i].ToString() == "Lunes")
{
lunes = "1";
}
else if (checkedListBox1.Items[i].ToString() == "Martes")
{
martes = "1";
}
else if (checkedListBox1.Items[i].ToString() == "Miercoles")
{
miercoles = "1";
}
else if (checkedListBox1.Items[i].ToString() == "Jueves")
{
jueves = "1";
}
else if (checkedListBox1.Items[i].ToString() == "Viernes")
{
viernes = "1";
}
else if (checkedListBox1.Items[i].ToString() == "Sabado")
{
sabado = "1";
}
else if (checkedListBox1.Items[i].ToString() == "Domingo")
{
domingo = "1";
}
}
}
if (DateTime.TryParse(ingreso, out t) && DateTime.TryParse(egreso, out t1) && txtHasta.Text == " / /")
{
ingreso = t.ToString("HH:mm");
egreso = t1.ToString("HH:mm");
string semana = "0";
if (!chkSemana.Checked)
{
semana = TSemana.Text;
}
HorariosProfesionales h = new HorariosProfesionales(0, prof, ingreso, egreso, Convert.ToDateTime(txtDesde.Text), lunes, martes, miercoles, jueves, viernes, sabado, domingo, semana);
if (idhorario == 0)
{
controlh.Agregar(h);
}
else
{
h.IdhorariosProfesionales = idhorario;
controlh.Modificar(h);
idhorario = 0;
}
frmHorariosProfesionales_Load(sender, e);
}
else if (DateTime.TryParse(ingreso, out t) && DateTime.TryParse(egreso, out t1) && txtHasta.Text != " / /")
{
ingreso = t.ToString("HH:mm");
egreso = t1.ToString("HH:mm");
string semana = "0";
if (!chkSemana.Checked)
{
semana = TSemana.Text;
}
HorariosProfesionales h = new HorariosProfesionales(0, prof, ingreso, egreso, Convert.ToDateTime(txtDesde.Text), Convert.ToDateTime(txtHasta.Text), lunes, martes, miercoles, jueves, viernes, sabado, domingo, semana);
if (idhorario == 0)
{
controlh.Agregar(h);
}
else
{
h.IdhorariosProfesionales = idhorario;
controlh.Modificar(h);
idhorario = 0;
}
frmHorariosProfesionales_Load(sender, e);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
txtDesde.Text = "";
txtHasta.Text = "";
txtIng.Text = "";
txtEgr.Text = "";
TSemana.Text = "";
}
}
public void cargagrilla()
{
try
{
laux = new List<grilla>();
dataGridView1.ColumnHeadersVisible = true;
DataGridViewCellStyle columnHeaderStyle = new DataGridViewCellStyle();
columnHeaderStyle.BackColor = Color.Beige;
columnHeaderStyle.Font = new Font("Verdana", 10, FontStyle.Bold);
dataGridView1.GridColor = Color.Black;
dataGridView1.ColumnHeadersDefaultCellStyle = columnHeaderStyle;
dataGridView1.DefaultCellStyle.BackColor = Color.Gray;
DataTable dt = oacceso.leerDatos("call sp_protrabaja('" + monthCalendar1.SelectionRange.Start.ToString("yyyy-MM-dd") + "')");
dataGridView1.ColumnCount = dt.Rows.Count + 1;
dataGridView1.Columns[0].Name = "Horario";
dataGridView1.Columns[0].Frozen = true;
DateTime start = DateTime.Parse("08:00");
DateTime start1 = DateTime.Parse("08:00");
DateTime end = DateTime.Parse("22:00");
int row = 0;
while (start <= end)
{
dataGridView1.Rows.Add(start.TimeOfDay.ToString());
dataGridView1.Rows[row].Cells[0].Style.ForeColor = Color.White;
start1 = start.AddMinutes(60);
start = start1;
row++;
}
HorariosProfesionales h = null;
int x = 1;
foreach (DataRow dr in dt.Rows)
{
Profesionales p = new Profesionales(Convert.ToInt32(dr["idprofesionales"]), Convert.ToString(dr["profesional"]), "", null, "", "", "", 1,0,0);
int cantidad = Convert.ToInt32(Convert.ToString(dr["horario"]).Substring(Convert.ToString(dr["horario"]).Length - 1, 1));
string query = Convert.ToString(dr["horario"]);
if (Convert.ToString(dr["horasmanuales"]) != "")
{
int canthorasmanuales = 0;
canthorasmanuales = Convert.ToInt32(Convert.ToString(dr["horasmanuales"]).Substring(Convert.ToString(dr["horasmanuales"]).LastIndexOf(';') + 1, Convert.ToString(dr["horasmanuales"]).Length - (Convert.ToString(dr["horasmanuales"]).LastIndexOf(';') + 1)));
cantidad = cantidad + canthorasmanuales;
query = query.Substring(0,query.Length - 1);
query = query + Convert.ToString(dr["horasmanuales"]);
}
int desde = 0;
int hasta = 5;
for (int z = 1; z <= cantidad; z++)
{
string ingreso = query.Substring(desde, 5);
string egreso = query.Substring(hasta, 5);
query = query.Substring(11, query.Length - 11);
h = new HorariosProfesionales(0, p, ingreso, egreso, DateTime.Now, "", "", "", "", "", "", "", "");
dataGridView1.Columns[x].Name = p.Profesional;
gri = new grilla(x, -1, p.Idprofesionales.ToString());
laux.Add(gri);
foreach (DataGridViewRow dg in dataGridView1.Rows)
{
if (h.Egreso != "10000" && h.Egreso != "00000")
{
if (Convert.ToDateTime(dg.Cells[0].Value) >= Convert.ToDateTime(h.Ingreso) && Convert.ToDateTime(dg.Cells[0].Value) <= Convert.ToDateTime(h.Egreso))
{
int i = dataGridView1.Rows.IndexOf(dg);
this.dataGridView1.Rows[i].Cells[x].Style.BackColor = Color.White;
}
else
{
int i = dataGridView1.Rows.IndexOf(dg);
if (this.dataGridView1.Rows[i].Cells[x].Style.BackColor != Color.White)
{
this.dataGridView1.Rows[i].Cells[x].Style.BackColor = Color.Gray;
}
}
}
else
{
if (Convert.ToDateTime(dg.Cells[0].Value) == Convert.ToDateTime(h.Ingreso))
{
int i = dataGridView1.Rows.IndexOf(dg);
if (h.Egreso == "10000")
{
this.dataGridView1.Rows[i].Cells[x].Style.BackColor = Color.White;
}
else
{
this.dataGridView1.Rows[i].Cells[x].Style.BackColor = Color.Gray;
}
}
}
}
}
x++;
}
int semana = 0;
DateTime a = monthCalendar1.SelectionRange.Start;
CultureInfo myCI = new CultureInfo("en-US");
CalendarWeekRule myCWR = myCI.DateTimeFormat.CalendarWeekRule;
DayOfWeek myFirstDOW = myCI.DateTimeFormat.FirstDayOfWeek;
Calendar myCal = myCI.Calendar;
if (myCal.GetWeekOfYear(a, myCWR, myFirstDOW) % 2 == 0)
{
semana = 2;
}
else
{
semana = 1;
}
dt = oacceso.leerDatos("call sp_turnos('" + monthCalendar1.SelectionRange.Start.ToString("yyyy-MM-dd") + "','" + Convert.ToInt32(monthCalendar1.SelectionRange.Start.DayOfWeek) + "','" + semana + "')");
int col = 0;
int idp = 0;
foreach (DataRow dr in dt.Rows)
{
Profesionales p = new Profesionales(Convert.ToInt32(dr["idprofesionales"]),"","",null,"","","",0,0,0);
if (idp != p.Idprofesionales)
{
foreach (grilla aux in laux)
{
if (-1 == aux.Fila && aux.Id == p.Idprofesionales.ToString())
{
col = aux.Columna;
idp = p.Idprofesionales;
break;
}
}
}
int fila = Convert.ToInt32(Convert.ToString(dr["hora"]).Substring(0, 2))-8;
string fijo = Convert.ToString(dr["fijo"]);
int asistencia = Convert.ToInt32(Convert.ToString(dr["asistencia"]));
if (col != 0)
{
if (asistencia == 1)
{
grilla gri = new grilla(col, fila, Convert.ToString(dr["idturnos"]));
laux.Add(gri);
this.dataGridView1.Rows[fila].Cells[col].Style.BackColor = Color.Orange;
this.dataGridView1.Rows[fila].Cells[col].Value = Convert.ToString(dr["detalle"]) + " " + Convert.ToString(dr["sesion"]);
}
else
{
if (fijo == "s")
{
if (Convert.ToDateTime(dr["fecha"]) == monthCalendar1.SelectionRange.Start)
{
grilla gri = new grilla(col, fila, Convert.ToString(dr["idturnos"]));
laux.Add(gri);
}
else
{
grilla gri = new grilla(col, fila, Convert.ToString(dr["idturnos"]));
laux.Add(gri);
}
if (Convert.ToString(dr["suspendido"]) == "0")
{
this.dataGridView1.Rows[fila].Cells[col].Style.BackColor = Color.IndianRed;
this.dataGridView1.Rows[fila].Cells[col].Value = Convert.ToString(dr["detalle"]) + " " + Convert.ToString(dr["sesion"]);
}
else if (this.dataGridView1.Rows[fila].Cells[col].Style.BackColor != Color.Gray)
{
this.dataGridView1.Rows[fila].Cells[col].Style.BackColor = Color.LightBlue;
}
}
else if (fijo == "q")
{
if (Convert.ToDateTime(dr["fecha"]) == monthCalendar1.SelectionRange.Start)
{
grilla gri = new grilla(col, fila, Convert.ToString(dr["idturnos"]));
laux.Add(gri);
}
else
{
grilla gri = new grilla(col, fila, Convert.ToString(dr["idturnos"]));
laux.Add(gri);
}
if (Convert.ToString(dr["suspendido"]) == "0")
{
this.dataGridView1.Rows[fila].Cells[col].Style.BackColor = Color.CornflowerBlue;
this.dataGridView1.Rows[fila].Cells[col].Value = Convert.ToString(dr["detalle"]) + " " + Convert.ToString(dr["sesion"]);
}
else if (this.dataGridView1.Rows[fila].Cells[col].Style.BackColor != Color.Gray)
{
this.dataGridView1.Rows[fila].Cells[col].Style.BackColor = Color.LightBlue;
}
}
else
{
grilla gri = new grilla(col, fila, Convert.ToString(dr["idturnos"]));
laux.Add(gri);
this.dataGridView1.Rows[fila].Cells[col].Style.BackColor = Color.Green;
this.dataGridView1.Rows[fila].Cells[col].Value = Convert.ToString(dr["detalle"]) + " " + Convert.ToString(dr["sesion"]);
}
}
}
else
{
MessageBox.Show("ERROR: existen turnos para profesionales sin grilla horaria");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
try
{
int filaseleccionada = Convert.ToInt32(this.dataGridView1.CurrentRow.Index);
int idhorarioprof = Convert.ToInt32(dataGridView1[0, filaseleccionada].Value);
HorariosProfesionales h = new HorariosProfesionales(idhorarioprof, null, "", "", DateTime.Now, "", "", "", "", "", "", "","");
DialogResult dialogResult = MessageBox.Show("Esta seguro de eliminar el Horario seleccionado ?", "Eliminar Configuracion Horarios", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
controlh.Borrar(h);
}
frmHorariosProfesionales_Load(sender, e);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
