HR Management system part 2

click here to download source code

Group By and ToLookup in Linq C#

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;



namespace ConsoleApplication1

{

    class student

    {

        public int studentID { get; set; }

        public string studentName { get; set; }

        public int Age { get; set; }

    }

    class Program

    {

        static void Main(string[] args)

        {

            List<student> li = new List<student>()

          {



             new student() { studentID = 5, studentName = "Ron" , Age = 21 },

            new student() { studentID = 6, studentName = "Chris",  Age = 18 },

             new student() { studentID = 7, studentName = "Rob",Age = 19  },

            new student() { studentID = 8, studentName = "Rob",Age = 21  },

            new student() { studentID = 1, studentName = "John", Age = 18 },

            new student() { studentID = 2, studentName = "Steve",  Age = 21 },

            new student() { studentID = 3, studentName = "Bill",  Age = 25 },

            new student() { studentID = 4, studentName = "Ram" , Age = 19 },

            new student() { studentID = 9, studentName = "Bill",Age = 19  },



        };



           // var agegroup = li.GroupBy(x => x.Age).ToList();

            var agegroup = li.ToLookup(x => x.Age).ToList();

            foreach (var group in agegroup)

            {

                Console.ForegroundColor = System.ConsoleColor.Green;



                Console.WriteLine("====AGE:"+group.Key+"====");

                Console.ForegroundColor = System.ConsoleColor.Red;



                foreach (var item  in group)

                {

                    Console.WriteLine(item.studentName);

                }

               

            }





     





        }

    }

}

Order by, Order by Descending, then by and then by Descending in linq c#

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;



namespace ConsoleApplication1

{

    class Program

    {

        static void Main(string[] args)

        {

            List<student> li = new List<student>()

          {



             new student() { studentID = 5, studentName = "Ron" , Age = 31 },

            new student() { studentID = 6, studentName = "Chris",  Age = 17 },

             new student() { studentID = 7, studentName = "Rob",Age = 19  },

            new student() { studentID = 8, studentName = "Rob",Age = 21  },

            new student() { studentID = 1, studentName = "John", Age = 18 },

            new student() { studentID = 2, studentName = "Steve",  Age = 21 },

            new student() { studentID = 3, studentName = "Bill",  Age = 25 },

            new student() { studentID = 4, studentName = "Ram" , Age = 20 },

         

            new student() { studentID = 9, studentName = "Bill",Age = 19  },



        };



           // var list = li.OrderBy(x => x.studentID).ToList();

          //  var list = li.OrderByDescending(x => x.studentName).ToList();

          //  var list = li.OrderByDescending(x => x.studentName).ThenBy(x=>x.Age).ToList();

            var list = li.OrderByDescending(x => x.studentName).ThenByDescending(x=>x.Age).ToList();

            foreach (var item in list)

            {

                Console.WriteLine("id: "+item.studentID+"---Name: "+item.studentName+"---age:"+item.Age);

            }



     





        }

    }

}

--------------------------------------------------------------------------------------------------------------

 public int studentID { get; set; }

        public string studentName { get; set; }

        public int Age { get; set; }

Introduction to Linq query in C#

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;



namespace ConsoleApplication1

{

    class Program

    {

        static void Main(string[] args)

        {

            List<student> li = new List<student>()

          {



            new student() { studentID = 1, studentName = "John", Age = 18 },

            new student() { studentID = 2, studentName = "Steve",  Age = 21 },

            new student() { studentID = 3, studentName = "Bill",  Age = 25 },

            new student() { studentID = 4, studentName = "Ram" , Age = 20 },

            new student() { studentID = 5, studentName = "Ron" , Age = 31 },

            new student() { studentID = 6, studentName = "Chris",  Age = 17 },

            new student() { studentID = 7, studentName = "Rob",Age = 19  },

        };





            List<student> teenagerlist = li.Where(x => x.Age > 12 && x.Age < 20).ToList();

            Console.WriteLine("Teenager students: ");

            foreach (student item in teenagerlist)

            {

                Console.WriteLine("Name: "+item.studentName);

            }





        }

    }

}

----------------------------------------------------------------------------------------------------------------

class student

    {

        public int studentID { get; set; }

        public string studentName { get; set; }

        public int Age { get; set; }

    }

HR Management system ASP.NET C# PART-1

click here to download the source code

insert data using Entity Framewrok database 1st Approach in windows from

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using WindowsFormsApplication9.Model;



namespace WindowsFormsApplication9

{

    public partial class Form1 : Form

    {

        db1708c1Entities db = new db1708c1Entities();

        tbl_student s = new tbl_student();

        public Form1()

        {

            InitializeComponent();

        }



        private void button2_Click(object sender, EventArgs e)

        {

           

            s.name = textBox1.Text;

            s.dob = dateTimePicker1.Value;

            s.contatct = textBox2.Text;

            if (s.C_image==null)

            {

                s.C_image = @"C:\images\unknown.png";

            }

            db.tbl_student.Add(s);

            db.SaveChanges();

            MessageBox.Show("Data successfully inserted......");

            dataGridView1.DataSource = db.tbl_student.ToList();

        }



        private void Form1_Load(object sender, EventArgs e)

        {

            dataGridView1.DataSource = db.tbl_student.ToList();

        }



        private void button1_Click(object sender, EventArgs e)

        {

            OpenFileDialog op = new OpenFileDialog();

            op.Filter = "Image Files(*.jpg; *.jpeg; *.gif; *.bmp)|*.jpg; *.jpeg; *.gif; *.bmp";

            if (op.ShowDialog() == DialogResult.OK)

            {

                pictureBox1.Image = new Bitmap(op.FileName);

                pictureBox1.SizeMode = PictureBoxSizeMode.StretchImage;

                s.C_image = op.FileName;

               

            }

        }

    }

}

How to delete data from sql server using Windwos form c#

Click here to download the source code