Exemple #1
0
        private void Turnero_Load(object sender, EventArgs e)
        {
            ///////////////////////////////////////////////////

            string cmdtest = "select deuda, descripcion, idturnos from turnos t inner join clientes c on t.idcliente = c.idclientes where deuda > 0";
            DataTable dt = new DataTable();
            dt = oacceso.leerDatos(cmdtest);
            foreach (DataRow dr in dt.Rows)
            {
                Button tmpButton = new Button();
                string nombre = Convert.ToString(dr["descripcion"]) + " " + Convert.ToString(dr["deuda"]);
                string name = Convert.ToString(dr["idturnos"]);
                System.Windows.Forms.ToolTip ToolTip1 = new System.Windows.Forms.ToolTip();
                ToolTip1.SetToolTip(tmpButton, nombre);
                tmpButton.Name = name;
                tmpButton.Text = nombre;
                tmpButton.Font = new Font("Verdana", 6, FontStyle.Bold);
                tmpButton.Size = new Size(132, 23);
                tmpButton.BackColor = Color.GreenYellow;
                tmpButton.Click += new System.EventHandler(this.manejador_de_evento_botones_generados);
                pnlContainer.Controls.Add(tmpButton);
            }

            ///////////////////////////////////////////////////
            while (fin.DayOfWeek != DayOfWeek.Sunday)
            {
               fin = fin.AddDays(1);
            }
            while (inicio.DayOfWeek != DayOfWeek.Monday)
            {
               inicio = inicio.AddDays(-1);
            }
            maskedTextBox1.Text = inicio.ToString("dd/MM/yyyy");
            maskedTextBox2.Text = fin.ToString("dd/MM/yyyy");
            dataGridView1.Columns.Clear();
            // Create an unbound DataGridView by declaring a column count.
            dataGridView1.ColumnCount = 8;
            dataGridView1.ColumnHeadersVisible = true;

            // Set the column header style.
            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.Beige;
            // Set the column header names.
            dataGridView1.Columns[0].Name = "Horas";
            dataGridView1.Columns[1].Name = "Lunes";
            dataGridView1.Columns[2].Name = "Martes";
            dataGridView1.Columns[3].Name = "Miercoles";
            dataGridView1.Columns[4].Name = "Jueves";
            dataGridView1.Columns[5].Name = "Viernes";
            dataGridView1.Columns[6].Name = "Sabado";
            dataGridView1.Columns[7].Name = "Domingo";
            dt = new DataTable();
            dt = oacceso.leerDatos("select hora from configuraciones where codigo = 'horaini'");
            DateTime start = DateTime.Parse("10:00:00");
            DateTime start1 = DateTime.Parse("10:00:00");
            DateTime end = DateTime.Parse("23:00:00");
            foreach (DataRow dr in dt.Rows)
            {
                start = DateTime.Parse(Convert.ToString(dr["hora"]));
                start1 = DateTime.Parse(Convert.ToString(dr["hora"]));
            }
            dt = oacceso.leerDatos("select hora from configuraciones where codigo = 'horafin'");
            foreach (DataRow dr in dt.Rows)
            {
                end = DateTime.Parse(Convert.ToString(dr["hora"]));
            }

            while (start <= end)
            {
                dataGridView1.Rows.Add(start.TimeOfDay.ToString());
                start1 = start.AddMinutes(30);
                start = start1;
            }
            lista.Clear();
            dt = oacceso.leerDatos("select * from novedades where fecha between '" + inicio.ToString("yyyy-MM-dd") + "' and '" + fin.ToString("yyyy-MM-dd") + "'");
            lista.Clear();
            foreach (DataRow dr in dt.Rows)
            {
                novedades onovedades = new novedades(Convert.ToInt32(dr["idturno"]), Convert.ToString(dr["fecha"]));
                lista.Add(onovedades);
            }
            dt = oacceso.leerDatos("select * from turnos where fecha between '" + inicio.ToString("yyyy-MM-dd") + "' and '" + fin.ToString("yyyy-MM-dd") + "' or idcliente is not null");

            foreach (DataRow dr in dt.Rows)
            {
                string idt = Convert.ToString(dr["idturnos"]);
                string tipo = Convert.ToString(dr["fecha"]);
                {
                    tipo = "";
                }
                string horaini = Convert.ToString(dr["ingreso"]);
                string horafin = Convert.ToString(dr["egreso"]);
                DateTime dateValue = DateTime.Today;
                //int dia = (int) dateValue.DayOfWeek;
                int dia = Convert.ToInt32(dr["dia"]);
                string nombre = Convert.ToString(dr["nombre"]);
                string id = Convert.ToString(dr["idcliente"]);
                if (id != "")
                {
                    dt = oacceso.leerDatos("select descripcion from clientes where idclientes = '" + id + "'");
                    foreach (DataRow d1r in dt.Rows)
                    {
                        nombre = Convert.ToString(d1r["descripcion"]);
                    }
                }
                foreach (DataGridViewRow row in dataGridView1.Rows)
                {
                    Random randonGen = new Random();
                    Color randomColor = Color.FromArgb(randonGen.Next(255), randonGen.Next(255),
                    randonGen.Next(255));

                    if (horaini == Convert.ToString(row.Cells[0].Value))
                    {

                        int i = dataGridView1.Rows.IndexOf(row);
                        if (tipo == "")
                        {
                            bool esta = false;

                            foreach (novedades aux in lista)
                            {
                                DateTime fecha = Convert.ToDateTime(aux.Fecha);
                                if (Convert.ToInt32(idt) == aux.idTurno)
                                {
                                    if (fecha >= inicio && fecha <= fin)
                                    {
                                        esta = true;
                                    }
                                }
                            }
                            if (esta == false)
                            {
                                gri = new grilla(dia, i, idt);
                                laux.Add(gri);
                                this.dataGridView1.Rows[i].Cells[dia].Value = nombre;
                                this.dataGridView1.Rows[i].Cells[dia].Style.BackColor = Color.Red;
                                if (this.dataGridView1.Rows[i].Cells[dia].Style.BackColor == Color.Aquamarine)
                                {
                                    this.dataGridView1.Rows[i].Cells[dia].Style.BackColor = Color.Gold;
                                }
                                if (randomColor == Color.Black || randomColor == Color.MidnightBlue)
                                {
                                    this.dataGridView1.Rows[i].Cells[dia].Style.ForeColor = Color.White;
                                }
                            }
                        }
                        else
                        {
                            DateTime fecha = Convert.ToDateTime(tipo);
                            if (fecha >= inicio && fecha <= fin)
                            {
                                gri = new grilla(dia, i, idt);
                                laux.Add(gri);
                                this.dataGridView1.Rows[i].Cells[dia].Value = nombre + " " + fecha.ToString("dd/MM/yyyy");
                                this.dataGridView1.Rows[i].Cells[dia].Style.BackColor = Color.Orange;
                            }
                        }
                        start = DateTime.Parse(horaini);
                        start1 = DateTime.Parse(horaini);
                        end = DateTime.Parse(horafin);
                        DateTime end1 = end.AddMinutes(-30);
                        while (start < end1)
                        {
                            i++;
                            if (tipo == "")
                            {
                                bool esta = false;

                                foreach (novedades aux in lista)
                                {
                                    DateTime fecha = Convert.ToDateTime(aux.Fecha);
                                    if (Convert.ToInt32(idt) == aux.idTurno)
                                    {
                                        if (fecha >= inicio && fecha <= fin)
                                        {
                                            esta = true;
                                        }
                                    }
                                }
                                if (esta == false)
                                {
                                    gri = new grilla(dia, i, idt);
                                    laux.Add(gri);
                                    this.dataGridView1.Rows[i].Cells[dia].Value = nombre;
                                    this.dataGridView1.Rows[i].Cells[dia].Style.BackColor = Color.Red;
                                    if (this.dataGridView1.Rows[i].Cells[dia].Style.BackColor == Color.Aquamarine)
                                    {
                                        this.dataGridView1.Rows[i].Cells[dia].Style.BackColor = Color.Gold;
                                    }
                                    if (randomColor == Color.Black || randomColor == Color.MidnightBlue)
                                    {
                                        this.dataGridView1.Rows[i].Cells[dia].Style.ForeColor = Color.White;
                                    }
                                }
                            }
                            else
                            {
                                DateTime fecha = Convert.ToDateTime(tipo);
                                if (fecha >= inicio && fecha <= fin)
                                {
                                    gri = new grilla(dia, i, idt);
                                    laux.Add(gri);
                                    this.dataGridView1.Rows[i].Cells[dia].Value = nombre + " " + fecha.ToString("dd/MM/yyyy");
                                    this.dataGridView1.Rows[i].Cells[dia].Style.BackColor = Color.Orange;

                                }
                            }
                            start1 = start.AddMinutes(30);
                            start = start1;
                        }
                        break;
                    }

                    else if (horafin == Convert.ToString(row.Cells[0].Value))
                    {
                        gri = new grilla(dia, dataGridView1.Rows.IndexOf(row) - 1, idt);
                        laux.Add(gri);
                        this.dataGridView1.Rows[dataGridView1.Rows.IndexOf(row) - 1].Cells[dia].Value = nombre + " " + tipo;

                        this.dataGridView1.Rows[dataGridView1.Rows.IndexOf(row) - 1].Cells[dia].Style.BackColor = Color.Red;
                        if (this.dataGridView1.Rows[dataGridView1.Rows.IndexOf(row) - 1].Cells[dia].Style.BackColor == Color.Aquamarine)
                        {
                            this.dataGridView1.Rows[dataGridView1.Rows.IndexOf(row) - 1].Cells[dia].Style.BackColor = Color.Gold;
                        }
                        if (randomColor == Color.Black || randomColor == Color.MidnightBlue)
                        {
                            this.dataGridView1.Rows[dataGridView1.Rows.IndexOf(row) - 1].Cells[dia].Style.ForeColor = Color.White;
                        }

                    }

                }
            }
        }
Exemple #2
0
        private void Turnero_Activated(object sender, EventArgs e)
        {
            ///////////////////////////////////////////////////

            ///////////////////////////////////////////////////
            while (fin.DayOfWeek != DayOfWeek.Sunday)
            {
                fin = fin.AddDays(1);
            }
            while (inicio.DayOfWeek != DayOfWeek.Monday)
            {
                inicio = inicio.AddDays(-1);
            }
            maskedTextBox1.Text = inicio.ToString("dd/MM/yyyy");
            maskedTextBox2.Text = fin.ToString("dd/MM/yyyy");
            dataGridView1.Columns.Clear();
            // Create an unbound DataGridView by declaring a column count.
            dataGridView1.ColumnCount = 8;
            dataGridView1.ColumnHeadersVisible = true;

            // Set the column header style.
            DataGridViewCellStyle columnHeaderStyle = new DataGridViewCellStyle();

            columnHeaderStyle.BackColor = Color.Beige;
            columnHeaderStyle.Font = new Font("Verdana", 10, FontStyle.Bold);
            dataGridView1.ColumnHeadersDefaultCellStyle = columnHeaderStyle;
            dataGridView1.DefaultCellStyle.BackColor = Color.Beige;
            dataGridView1.GridColor = Color.Black;
            // Set the column header names.
            dataGridView1.Columns[0].Name = "Horas";
            this.dataGridView1.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopCenter;
            dataGridView1.Columns[1].Name = "Lunes";
            this.dataGridView1.Columns[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopCenter;
            dataGridView1.Columns[2].Name = "Martes";
            this.dataGridView1.Columns[2].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopCenter;
            dataGridView1.Columns[3].Name = "Miercoles";
            this.dataGridView1.Columns[3].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopCenter;
            dataGridView1.Columns[4].Name = "Jueves";
            this.dataGridView1.Columns[4].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopCenter;
            dataGridView1.Columns[5].Name = "Viernes";
            this.dataGridView1.Columns[5].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopCenter;
            dataGridView1.Columns[6].Name = "Sabado";
            this.dataGridView1.Columns[6].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopCenter;
            dataGridView1.Columns[7].Name = "Domingo";
            this.dataGridView1.Columns[7].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopCenter;
            DataTable dt = new DataTable();
            dt = oacceso.leerDatos("select hora from configuraciones where codigo = 'horaini'");
            DateTime start = DateTime.Parse("10:00:00");
            DateTime start1 = DateTime.Parse("10:00:00");
            DateTime end = DateTime.Parse("23:00:00");
            string horain = "";
            string horaf = "";
            foreach (DataRow dr in dt.Rows)
            {
                start = DateTime.Parse(Convert.ToString(dr["hora"]));
                start1 = DateTime.Parse(Convert.ToString(dr["hora"]));
                horain = Convert.ToString(dr["hora"]);
            }
            dt = oacceso.leerDatos("select hora from configuraciones where codigo = 'horafin'");
            foreach (DataRow dr in dt.Rows)
            {
                end = DateTime.Parse(Convert.ToString(dr["hora"]));
                horaf = Convert.ToString(dr["hora"]);
            }
            if (String.Compare(horain, horaf) > 0)
            {
                end = end.AddDays(1);
            }
            while (start <= end)
            {

                dataGridView1.Rows.Add(start.TimeOfDay.ToString());
                start1 = start.AddMinutes(30);
                start = start1;
            }
            dt = oacceso.leerDatos("select * from novedades where fecha between '" + inicio.ToString("yyyy-MM-dd") + "' and '" + fin.ToString("yyyy-MM-dd") + "'");
            lista.Clear();
            foreach (DataRow dr in dt.Rows)
            {
                novedades onovedades = new novedades(Convert.ToInt32(dr["idturno"]), Convert.ToString(dr["fecha"]));
                lista.Add(onovedades);
            }
            dt = oacceso.leerDatos("select * from turnos where fecha between '" + inicio.ToString("yyyy-MM-dd") + "' and '" + fin.ToString("yyyy-MM-dd") + "' or idcliente is not null");
            foreach (DataRow dr in dt.Rows)
            {
                string idt = Convert.ToString(dr["idturnos"]);
                string tipo = Convert.ToString(dr["fecha"]);
                if (tipo == "0000-00-00")
                {
                    tipo = "";
                }
                string horaini = Convert.ToString(dr["ingreso"]);
                string horafin = Convert.ToString(dr["egreso"]);
                DateTime dateValue = DateTime.Today;
                //int dia = (int) dateValue.DayOfWeek;
                int dia = Convert.ToInt32(dr["dia"]);
                string nombre = Convert.ToString(dr["nombre"]);
                string id = Convert.ToString(dr["idcliente"]);
                if (id != "")
                {
                    dt = oacceso.leerDatos("select descripcion from clientes where idclientes = '" + id + "'");
                    foreach (DataRow d1r in dt.Rows)
                    {
                        nombre = Convert.ToString(d1r["descripcion"]);
                    }
                }
                foreach (DataGridViewRow row in dataGridView1.Rows)
                {
                    int ix = 0;
                    Random randonGen = new Random();
                    Color randomColor = Color.FromArgb(randonGen.Next(255), randonGen.Next(255),
                    randonGen.Next(255));
                    if (horaini == Convert.ToString(row.Cells[0].Value))
                    {

                        int i = dataGridView1.Rows.IndexOf(row);
                        if (tipo == "")
                        {
                            bool esta = false;

                            foreach (novedades aux in lista)
                            {
                                DateTime fecha = Convert.ToDateTime(aux.Fecha);
                                if (Convert.ToInt32(idt) == aux.idTurno)
                                {
                                    if (fecha >= inicio && fecha <= fin)
                                    {
                                        dt = oacceso.leerDatos("select 'hay turno' as ok, nombre from turnos where fecha = '" + fecha.ToString("yyyy-MM-dd") + "' and idcliente is not null");
                                        bool ok = true;
                                        string n ="";
                                        foreach (DataRow d2r in dt.Rows)
                                        {
                                            if ((Convert.ToString(d2r["ok"])) == "hay turno")
                                            {
                                                ok = false;
                                                n = Convert.ToString(d2r["nombre"]);
                                            }
                                            else ok = true;
                                        }
                                        esta = true;
                                        if (ok == true)
                                        {
                                            gri = new grilla(dia, i, idt);
                                            laux.Add(gri);
                                            this.dataGridView1.Rows[i].Cells[dia].Value = "Turno suspendido";
                                            this.dataGridView1.Rows[i].Cells[dia].Style.Font = new Font(this.Font, FontStyle.Bold);
                                            this.dataGridView1.Rows[i].Cells[dia].Style.BackColor = Color.Aquamarine;
                                        }
                                        else
                                        {
                                            gri = new grilla(dia, i, idt);
                                            laux.Add(gri);
                                            this.dataGridView1.Rows[i].Cells[dia].Value = n + " " + fecha.ToShortDateString();
                                            this.dataGridView1.Rows[i].Cells[dia].Style.Font = new Font(this.Font, FontStyle.Bold);
                                            this.dataGridView1.Rows[i].Cells[dia].Style.BackColor = Color.Aquamarine;
                                        }
                                    }
                                }
                            }
                            if (esta == false)
                            {
                                gri = new grilla(dia, i, idt);
                                laux.Add(gri);
                                if (ix > 0)
                                {
                                    this.dataGridView1.Rows[i].Cells[dia].Value = "X";
                                }
                                else
                                {
                                    this.dataGridView1.Rows[i].Cells[dia].Value = nombre;
                                    ix++;
                                }
                                this.dataGridView1.Rows[i].Cells[dia].Style.BackColor = Color.Red;
                                if (this.dataGridView1.Rows[i].Cells[dia].Style.BackColor == Color.Aquamarine)
                                {
                                    this.dataGridView1.Rows[i].Cells[dia].Style.BackColor = Color.Gold;
                                }
                                if (randomColor == Color.Black || randomColor == Color.MidnightBlue)
                                {
                                    this.dataGridView1.Rows[i].Cells[dia].Style.ForeColor = Color.White;
                                }
                            }
                        }
                        else
                        {
                            DateTime fecha = Convert.ToDateTime(tipo);
                            if (fecha >= inicio && fecha <= fin)
                            {
                                gri = new grilla(dia, i, idt);
                                laux.Add(gri);
                                if (ix > 0)
                                {
                                    this.dataGridView1.Rows[i].Cells[dia].Value = "X";
                                }
                                else
                                {
                                    this.dataGridView1.Rows[i].Cells[dia].Value = nombre + " " + fecha.ToString("dd/MM/yyyy");
                                    ix++;
                                }
                                this.dataGridView1.Rows[i].Cells[dia].Style.BackColor = Color.Orange;
                            }
                        }
                        start = DateTime.Parse(horaini);
                        start1 = DateTime.Parse(horaini);
                        end = DateTime.Parse(horafin);
                        DateTime end1 = end.AddMinutes(-30);
                        while (start < end1)
                        {
                            i++;
                            if (tipo == "")
                            {
                                bool esta = false;

                                foreach (novedades aux in lista)
                                {
                                    DateTime fecha = Convert.ToDateTime(aux.Fecha);
                                    if (Convert.ToInt32(idt) == aux.idTurno)
                                    {
                                        if (fecha >= inicio && fecha <= fin)
                                        {
                                            dt = oacceso.leerDatos("select 'hay turno' as ok, nombre from turnos where fecha = '" + fecha.ToString("yyyy-MM-dd") + "' and idcliente is not null");
                                            bool ok = true;
                                            string n = "";
                                            foreach (DataRow d2r in dt.Rows)
                                            {
                                                if ((Convert.ToString(d2r["ok"])) == "hay turno")
                                                {
                                                    ok = false;
                                                    n = Convert.ToString(d2r["nombre"]);
                                                }
                                                else ok = true;
                                            }
                                            esta = true;
                                            if (ok == true)
                                            {
                                                gri = new grilla(dia, i, idt);
                                                laux.Add(gri);
                                                this.dataGridView1.Rows[i].Cells[dia].Value = "Turno suspendido";
                                                this.dataGridView1.Rows[i].Cells[dia].Style.Font = new Font(this.Font, FontStyle.Bold);
                                                this.dataGridView1.Rows[i].Cells[dia].Style.BackColor = Color.Aquamarine;
                                            }
                                            else
                                            {
                                                gri = new grilla(dia, i, idt);
                                                laux.Add(gri);
                                                this.dataGridView1.Rows[i].Cells[dia].Value = n + " " + fecha.ToShortDateString();
                                                this.dataGridView1.Rows[i].Cells[dia].Style.Font = new Font(this.Font, FontStyle.Bold);
                                                this.dataGridView1.Rows[i].Cells[dia].Style.BackColor = Color.Aquamarine;
                                            }
                                        }
                                    }
                                }
                                if (esta == false)
                                {
                                    gri = new grilla(dia, i, idt);
                                    laux.Add(gri);
                                    if (ix > 0)
                                    {
                                        this.dataGridView1.Rows[i].Cells[dia].Value = "X";
                                    }
                                    else
                                    {
                                        this.dataGridView1.Rows[i].Cells[dia].Value = nombre;
                                    }
                                    this.dataGridView1.Rows[i].Cells[dia].Style.BackColor = Color.Red;
                                    if (this.dataGridView1.Rows[i].Cells[dia].Style.BackColor == Color.Aquamarine)
                                    {
                                        this.dataGridView1.Rows[i].Cells[dia].Style.BackColor = Color.Gold;
                                    }
                                    if (randomColor == Color.Black || randomColor == Color.MidnightBlue)
                                    {
                                        this.dataGridView1.Rows[i].Cells[dia].Style.ForeColor = Color.White;
                                    }
                                }
                            }
                            else
                            {
                                DateTime fecha = Convert.ToDateTime(tipo);
                                if (fecha >= inicio && fecha <= fin)
                                {
                                    gri = new grilla(dia, i, idt);
                                    laux.Add(gri);
                                    if (ix > 0)
                                    {
                                        this.dataGridView1.Rows[i].Cells[dia].Value = "X";
                                    }
                                    else
                                    {
                                        this.dataGridView1.Rows[i].Cells[dia].Value = nombre + " " + fecha.ToString("dd/MM/yyyy");
                                        ix++;
                                    }
                                    this.dataGridView1.Rows[i].Cells[dia].Style.BackColor = Color.Orange;
                                }
                            }
                            start1 = start.AddMinutes(30);
                            start = start1;
                        }
                        break;
                    }

                    else if (horafin == Convert.ToString(row.Cells[0].Value))
                    {
                        gri = new grilla(dia, dataGridView1.Rows.IndexOf(row) - 1, idt);
                        laux.Add(gri);
                        this.dataGridView1.Rows[dataGridView1.Rows.IndexOf(row) - 1].Cells[dia].Value = nombre + " " + tipo;

                        this.dataGridView1.Rows[dataGridView1.Rows.IndexOf(row) - 1].Cells[dia].Style.BackColor = Color.Red;
                        if (this.dataGridView1.Rows[dataGridView1.Rows.IndexOf(row) - 1].Cells[dia].Style.BackColor == Color.Aquamarine)
                        {
                            this.dataGridView1.Rows[dataGridView1.Rows.IndexOf(row) - 1].Cells[dia].Style.BackColor = Color.Gold;
                        }
                        if (randomColor == Color.Black || randomColor == Color.MidnightBlue)
                        {
                            this.dataGridView1.Rows[dataGridView1.Rows.IndexOf(row) - 1].Cells[dia].Style.ForeColor = Color.White;
                        }

                    }

                }
            }
        }