static void Main(string[] args) { opciones nopcion = new opciones(); string opcion = ""; while (true) { Console.Clear(); Console.WriteLine("********************************************************"); Console.WriteLine(""); Console.WriteLine("********Bienvenido al Sistema de Reservacion********"); Console.WriteLine(""); Console.WriteLine("*********************************************************"); Console.WriteLine(""); Console.WriteLine(" 1. --Nuevo Reservacion"); Console.WriteLine(" 2. --Lista de Clientes"); Console.WriteLine(" 3. --Lista de Habitaciones disponibles"); Console.WriteLine(" 4. --Lista de Reservaciones"); Console.WriteLine(" 5. --Salir"); opcion = Console.ReadLine(); switch (opcion) { case "1": nopcion.CrearReservacion(); break; case "2": nopcion.listaclientes(); break; case "3": nopcion.listahabitaciones(); break; case "4": nopcion.ListaReservaciones(); break; default: break; } if (opcion == "5") { break; } } }
public static List <op_comision> GellAllCargos(vista v, opciones o, string acc) { string sql = null; if (o == opciones.parametro_fecha) { if (v == vista.maestro) { sql = @"SELECT 'SALIDAS' AS ACCESO,ope, nomempl, count(nrec) as viajes,sum(rkm) as recorrido, sum(tifkm) as rec_km_fle, sum(tifkm*0.07) as comision FROM `logicop`.`salidasmat` join empleados on codempl=ope where fech between @fi and @ff group by 1,2 union SELECT 'ENTRADAS' AS ACCESO,ope, nomempl, count(nrec) as viajes,sum(rkm) as recorrido, sum(tifkm) as rec_km_fle, sum(tifkm*0.07) as comision FROM `logicop`.`entradasmat` join empleados on codempl=ope where fech between @fi and @ff group by 1,2 ;"; } if (v == vista.detalle) { sql = @"SELECT 'SALIDAS' AS ACCESO,ope, nomempl, nrec as recibo,rkm as recorrido, tifkm as rec_km_fle, tifkm*0.07 as comision FROM `logicop`.`salidasmat` join empleados on codempl=ope where fech between @fi and @ff union SELECT 'ENTRADAS' AS ACCESO,ope, nomempl, nrec as viajes,rkm as recorrido, tifkm as rec_km_fle, tifkm*0.07 as comision FROM `logicop`.`entradasmat` join empleados on codempl=ope where fech between @fi and @ff"; } } if (o == opciones.parametro_fecha_operador) { if (v == vista.maestro) { sql = @"SELECT 'SALIDAS' AS ACCESO, ope, nomempl, count(nrec) as viajes,sum(rkm) as recorrido, sum(tifkm) as rec_km_fle, sum(tifkm*0.07) as comision FROM `logicop`.`salidasmat` join empleados on codempl=ope where ope=@op and fech between @fi and @ff group by 1,2 union SELECT 'ENTRADAS' AS ACCESO,ope, nomempl, count(nrec) as viajes,sum(rkm) as recorrido, sum(tifkm) as rec_km_fle, sum(tifkm*0.07) as comision FROM `logicop`.`entradasmat` join empleados on codempl=ope where ope=@op and fech between @fi and @ff group by 1,2;"; } if (v == vista.detalle) { sql = @"SELECT 'SALIDAS' AS ACCESO, ope, nomempl, nrec as recibo,rkm as recorrido, tifkm as rec_km_fle, tifkm*0.07 as comision FROM `logicop`.`salidasmat` join empleados on codempl=ope where ope=@op and fech between @fi and @ff union SELECT 'ENTRADAS' AS ACCESO, ope, nomempl, nrec as viajes,rkm as recorrido, tifkm as rec_km_fle, tifkm*0.07 as comision FROM `logicop`.`entradasmat` join empleados on codempl=ope where ope=@op and fech between @fi and @ff"; } } if (o == opciones.parametro_acceso) { string tabla = null; if (acc == "ENTRADAS") { tabla = "`logicop`.`entradasmat`"; } else { tabla = "`logicop`.`salidasmat`"; } sql = @"SELECT '" + acc + "' AS ACCESO, ope, nomempl, nrec as viajes,rkm as recorrido, tifkm as rec_km_fle, tifkm*0.07 as comision FROM " + tabla + " join empleados on codempl=ope where ope=@op and fech between @fi and @ff order by 2,3"; } List <op_comision> list = new List <op_comision>(); using (MySqlConnection conn = new MySqlConnection(ConfigurationManager.ConnectionStrings["default"].ToString())) { conn.Open(); MySqlCommand cmd = new MySqlCommand(sql, conn); cmd.Parameters.AddWithValue("@fi", op_var.a); cmd.Parameters.AddWithValue("@ff", op_var.b); cmd.Parameters.AddWithValue("@op", op_var.ope); MySqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows == true) { while (reader.Read()) { list.Add(LoadCargos(reader, v)); } } } return(list); }