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);
}
