/// <summary> /// Constructor Padrão /// </summary> /// <param name="db">Context para Dapper</param> /// <param name="dbContext">Context para Linq2db</param> public Movimentos(DapperContext db, LinqDbContext dbContext = null) { Db = db; _dbContext = dbContext; _meses = new Dictionary <int, string> { { 1, "Janeiro" }, { 2, "Fevereiro" }, { 3, "Março" }, { 4, "Abril" }, { 5, "Maio" }, { 6, "Junho" }, { 7, "Julho" }, { 8, "Agosto" }, { 9, "Setembro" }, { 10, "Outubro" }, { 11, "Novembro" }, { 12, "Dezembro" }, }; }
static void Main(string[] args) { LinqDbContext context = new LinqDbContext(); //2 activity var empdetails = from emp in context.Employee select emp; foreach (var i in empdetails) { Console.WriteLine(i.FirstName + "," + i.LastName + "," + i.EmployeeId + "," + i.Salary + "," + i.JoiningDate + "," + i.Department); } //3 activity foreach (var i in empdetails) { Console.WriteLine("FirstName:" + i.FirstName + "," + "LastName:" + i.LastName); } //4 activity var empdetails2 = from emp in context.Employee select new { EmployeeName = emp.FirstName }; foreach (var i in empdetails2) { Console.WriteLine(i); } //5 activity Console.WriteLine("Activity 5"); var empdetails3 = from emp in context.Employee select emp.FirstName.ToUpper(); foreach (var i in empdetails3) { Console.WriteLine(i); } //6 activity Console.WriteLine("Activity 6"); var empdetails5 = from emp in context.Employee select emp.FirstName.ToLower(); foreach (var i in empdetails5) { Console.WriteLine(i); } //7 activity Console.WriteLine("Activity 7"); var empdetails6 = (from emp in context.Employee select emp.Department).Distinct(); foreach (var i in empdetails6) { Console.WriteLine(i); } //8 activity Console.WriteLine("Activity 8"); var empdetails8 = from emp in context.Employee select emp.FirstName.Substring(0, 3); foreach (var i in empdetails8) { Console.WriteLine(i); } //9 activity Console.WriteLine("Activity 9"); var empdetails9 = from emp in context.Employee where emp.FirstName == "John" select emp.FirstName.IndexOf("o"); foreach (var i in empdetails9) { Console.WriteLine(i); } //10 activity Console.WriteLine("Activity 10"); var empdetails10 = from emp in context.Employee select emp.FirstName.TrimStart(); foreach (var i in empdetails10) { Console.WriteLine(i); } //11 activity Console.WriteLine("Activity 11"); var empdetails11 = from emp in context.Employee select emp.FirstName.TrimEnd(); foreach (var i in empdetails11) { Console.WriteLine(i); } //12 activity Console.WriteLine("Activity 12"); var empdetails12 = from emp in context.Employee select new { FirstName = emp.FirstName, Length = emp.FirstName.Length }; foreach (var i in empdetails12) { Console.WriteLine(i); } //13 activity Console.WriteLine("Activity 13"); var empdetails13 = from emp in context.Employee where emp.FirstName.Contains("o") select emp.FirstName.Replace("o", "$"); foreach (var i in empdetails13) { Console.WriteLine(i); } //15 activity Console.WriteLine("Activity 15"); var empdetails14 = from emp in context.Employee select new { FirstName = emp.FirstName, Year = emp.JoiningDate.Year, Month = emp.JoiningDate.Month, Date = emp.JoiningDate.Date }; foreach (var i in empdetails14) { Console.WriteLine(i); } //16 activity Console.WriteLine("Activity 16"); var empdetails16 = from emp in context.Employee orderby emp.FirstName ascending select emp.FirstName; foreach (var i in empdetails16) { Console.WriteLine(i); } //17 activity Console.WriteLine("Activity 17"); var empdetails17 = from emp in context.Employee orderby emp.FirstName descending select emp.FirstName; foreach (var i in empdetails17) { Console.WriteLine(i); } //18 activity Console.WriteLine("Activity 18"); var empdetails18 = from emp in context.Employee orderby emp.FirstName ascending, emp.Salary descending select new { emp.FirstName, emp.Salary }; foreach (var i in empdetails18) { Console.WriteLine(i); } //19 activity Console.WriteLine("Activity 19"); var empdetails19 = from emp in context.Employee where emp.FirstName == "John" || emp.FirstName == "Roy" select emp; foreach (var i in empdetails19) { Console.WriteLine(i.FirstName + "," + i.LastName + "," + i.EmployeeId + "," + i.Salary + "," + i.JoiningDate + "," + i.Department); } //20 activity Console.WriteLine("Activity 20"); var empdetails20 = from emp in context.Employee where emp.FirstName != "John" && emp.FirstName != "Roy" select emp; foreach (var i in empdetails20) { Console.WriteLine(i.FirstName + "," + i.LastName + "," + i.EmployeeId + "," + i.Salary + "," + i.JoiningDate + "," + i.Department); } //22 activity Console.WriteLine("Activity 22"); var empdetails22 = from emp in context.Employee where emp.FirstName.StartsWith("J") select emp; foreach (var i in empdetails22) { Console.WriteLine(i.FirstName + "," + i.LastName + "," + i.EmployeeId + "," + i.Salary + "," + i.JoiningDate + "," + i.Department); } //23 activity Console.WriteLine("Activity 23"); var empdetails23 = from emp in context.Employee where emp.FirstName.Contains("o") select emp; foreach (var i in empdetails23) { Console.WriteLine(i.FirstName + "," + i.LastName + "," + i.EmployeeId + "," + i.Salary + "," + i.JoiningDate + "," + i.Department); } //24 activity Console.WriteLine("Activity 24"); var empdetails24 = from emp in context.Employee where emp.FirstName.EndsWith("n") select emp; foreach (var i in empdetails24) { Console.WriteLine(i.FirstName + "," + i.LastName + "," + i.EmployeeId + "," + i.Salary + "," + i.JoiningDate + "," + i.Department); } //25 activity Console.WriteLine("Activity 25"); var empdetails25 = from emp in context.Employee where emp.FirstName.EndsWith("n") && emp.FirstName.Length == 4 select emp; foreach (var i in empdetails25) { Console.WriteLine(i.FirstName + "," + i.LastName + "," + i.EmployeeId + "," + i.Salary + "," + i.JoiningDate + "," + i.Department); } //26 activity Console.WriteLine("Activity 26"); var empdetails26 = from emp in context.Employee where emp.FirstName.StartsWith("J") && emp.FirstName.Length == 4 select emp; foreach (var i in empdetails26) { Console.WriteLine(i.FirstName + "," + i.LastName + "," + i.EmployeeId + "," + i.Salary + "," + i.JoiningDate + "," + i.Department); } //27 activity Console.WriteLine("Activity 27"); var empdetails27 = from emp in context.Employee where emp.Salary > 60000 select emp; foreach (var i in empdetails27) { Console.WriteLine(i.FirstName + "," + i.LastName + "," + i.EmployeeId + "," + i.Salary + "," + i.JoiningDate + "," + i.Department); } //29 activity Console.WriteLine("Activity 29"); IEnumerable <Employee> emps = context.Employee.Where <Employee>(e => e.Salary > 60000 && e.Salary < 80000).Select(e => e); foreach (var i in emps) { Console.WriteLine(i.FirstName + "," + i.LastName + "," + i.EmployeeId + "," + i.Salary + "," + i.JoiningDate + "," + i.Department); } //30 activity Console.WriteLine("Activity 30"); IEnumerable <Employee> emp1s = context.Employee.Where <Employee>(e => e.FirstName == "John" || e.FirstName == "Michael").Select(e => e); foreach (var i in emp1s) { Console.WriteLine(i.FirstName + "," + i.LastName + "," + i.EmployeeId + "," + i.Salary + "," + i.JoiningDate + "," + i.Department); } //31 activity Console.WriteLine("Activity 31"); IEnumerable <Employee> emp2s = context.Employee.Where <Employee>(e => e.JoiningDate.Year == 2020).Select(e => e); foreach (var i in emp2s) { Console.WriteLine(i.FirstName + "," + i.LastName + "," + i.EmployeeId + "," + i.Salary + "," + i.JoiningDate + "," + i.Department); } //35 activity Console.WriteLine("Activity 35"); var empdetails35 = from emp in context.Employee select new { emp.JoiningDate.Date, emp.JoiningDate.TimeOfDay }; foreach (var i in empdetails35) { Console.WriteLine(i); } //36 activity Console.WriteLine("Activity 36"); var empdetails36 = from emp in context.Employee select new { emp.JoiningDate.Date, emp.JoiningDate.TimeOfDay.Milliseconds }; foreach (var i in empdetails36) { Console.WriteLine(i); } //39 activity Console.WriteLine("Activity 39"); var empdetails39 = from emp in context.Employee where emp.LastName.Contains("%") select emp.LastName; foreach (var i in empdetails39) { Console.WriteLine(i); } //40 activity Console.WriteLine("Activity 40"); var empdetails40 = from emp in context.Employee where emp.LastName.Contains("%") select emp.LastName.Replace("%", ""); foreach (var i in empdetails40) { Console.WriteLine(i); } //41 activity Console.WriteLine("Activity 41"); var empdetails41 = from emp in context.Employee group emp by emp.Department into newGroup select new { Department = newGroup.Key, Salary = newGroup.Sum(x => x.Salary) }; foreach (var depart in empdetails41) { Console.WriteLine(depart); } //42 activity Console.WriteLine("Activity 42"); var empdetails42 = from emp in context.Employee group emp by emp.Department into newGroup orderby newGroup.Sum(x => x.Salary) descending select new { Department = newGroup.Key, Salary = newGroup.Sum(x => x.Salary) }; foreach (var depart in empdetails42) { Console.WriteLine(depart); } //43 activity Console.WriteLine("Activity 43"); var empdetails43 = from emp in context.Employee group emp by emp.Department into newGroup orderby newGroup.Sum(x => x.Salary) descending select new { Department = newGroup.Key, NoOfEmployees = newGroup.Count(), Salary = newGroup.Sum(x => x.Salary) }; foreach (var depart in empdetails43) { Console.WriteLine(depart); } //44 activity Console.WriteLine("Activity 44"); var empdetails44 = from emp in context.Employee group emp by emp.Department into newGroup orderby newGroup.Average(x => x.Salary) ascending select new { Department = newGroup.Key, Salary = newGroup.Average(x => x.Salary) }; foreach (var depart in empdetails44) { Console.WriteLine(depart); } //45 activity Console.WriteLine("Activity 45"); var empdetails45 = from emp in context.Employee group emp by emp.Department into newGroup orderby newGroup.Max(x => x.Salary) ascending select new { Department = newGroup.Key, Salary = newGroup.Max(x => x.Salary) }; foreach (var depart in empdetails45) { Console.WriteLine(depart); } //46 activity Console.WriteLine("Activity 46"); var empdetails46 = from emp in context.Employee group emp by emp.Department into newGroup orderby newGroup.Min(x => x.Salary) ascending select new { Department = newGroup.Key, Salary = newGroup.Min(x => x.Salary) }; foreach (var depart in empdetails46) { Console.WriteLine(depart); } //47 activity Console.WriteLine("Activity 47"); var empdetails47 = (from emp in context.Employee where emp.JoiningDate.Year == 2020 && emp.JoiningDate.Month == 2 select emp.EmployeeId).Count(); Console.WriteLine(empdetails47); //48 activity Console.WriteLine("Activity 48"); var empdetails48 = from emp in context.Employee group emp by emp.Department into newGroup where newGroup.Sum(x => x.Salary) > 80000 orderby newGroup.Sum(x => x.Salary) > 80000 descending select new { Department = newGroup.Key, Salary = newGroup.Sum(x => x.Salary) }; foreach (var depart in empdetails48) { Console.WriteLine(depart); } //49 activity Console.WriteLine("Activity 49"); var empdetails49 = from emp in context.Employee join incentive in context.Incentives on emp.EmployeeId equals incentive.EmployeeId where incentive.IncentiveAmount != 0 select new { Employee = emp.FirstName, IncentiveAmount = incentive.IncentiveAmount }; foreach (var depart in empdetails49) { Console.WriteLine(depart); } //50 activity Console.WriteLine("Activity 50"); var empdetails50 = from emp in context.Employee join incentive in context.Incentives on emp.EmployeeId equals incentive.EmployeeId where incentive.IncentiveAmount != 0 && incentive.IncentiveAmount > 3000 select new { Employee = emp.FirstName, IncentiveAmount = incentive.IncentiveAmount }; foreach (var depart in empdetails50) { Console.WriteLine(depart); } //51 activity Console.WriteLine("Activity 51"); var empdetails51 = (from emp in context.Employee join incentive in context.Incentives on emp.EmployeeId equals incentive.EmployeeId into t from rt in t.DefaultIfEmpty() select new { Employee = emp.FirstName, IncentiveAmount = rt.IncentiveAmount }).ToList(); foreach (var depart in empdetails51) { Console.WriteLine(depart); } //54 activity Console.WriteLine("Activity 54"); var empdetails53 = (from emp in context.Employee select emp.Salary).Take(2); foreach (var depart in empdetails53) { Console.WriteLine(depart); } //56 activity Console.WriteLine("Activity 56"); var empdetails56 = (from emp in context.Employee orderby emp.Salary descending select emp.Salary).Skip(1).First(); Console.WriteLine(empdetails56); //57 activity Console.WriteLine("Activity 57\nEnter Number:"); int num; num = Convert.ToInt32(Console.ReadLine()); var empdetails57 = (from emp in context.Employee orderby emp.Salary descending select emp.Salary).Skip(num - 1).First(); Console.WriteLine(empdetails57); //59 activity Console.WriteLine("Activity 59"); List <int> dataSource1 = new List <int>() { 1, 2, 3, 4, 5, 6 }; List <int> dataSource2 = new List <int>() { 1, 3, 5, 8, 9, 10 }; // var empdetails59 = dataSource1.Union(dataSource2); var empdetails59 = dataSource1.Concat(dataSource2); foreach (var depart in empdetails59) { Console.WriteLine(depart); } //60 activity Console.WriteLine("Activity 60"); var empdetails60 = from emp in context.Employee select emp; Console.WriteLine(empdetails60); }