public bool UpdateEmployeeSalary(SalaryUpdateModel salaryUpdateModel)
        {
            SqlConnection SalaryConnection = ConnectionSetup();
            int           salary           = 0;
            bool          update           = false;

            try
            {
                using (SalaryConnection)
                {
                    SalaryDetailModel displayModel = new SalaryDetailModel();
                    SqlCommand        command      = new SqlCommand("spUpdateEmployeeSalary_", SalaryConnection);
                    command.CommandType = System.Data.CommandType.StoredProcedure;
                    var cmd = new SqlCommand("Select Id from Employee where EmployeeName='Terissa'", SalaryConnection);
                    SalaryConnection.Open();

                    var reader = cmd.ExecuteReader();

                    if (reader.Read())
                    {
                        salaryUpdateModel.SalaryId = Convert.ToInt32(reader.GetInt32(0));
                    }
                    reader.Close();
                    command.Parameters.AddWithValue("@id", salaryUpdateModel.SalaryId);
                    command.Parameters.AddWithValue("@salary", salaryUpdateModel.EmployeeSalary);
                    command.Parameters.AddWithValue("@EmpID", salaryUpdateModel.EmployeeId);
                    SqlDataReader dr = command.ExecuteReader();
                    if (dr.HasRows)
                    {
                        while (dr.Read())
                        {
                            displayModel.EmployeeId     = Convert.ToInt32(dr["Id"]);
                            displayModel.EmployeeName   = dr["Name"].ToString();
                            displayModel.EmployeeSalary = Convert.ToInt32(dr["Salary"]);
                            Console.WriteLine(displayModel.EmployeeId + " " + displayModel.EmployeeName + " " + displayModel.EmployeeSalary);
                            Console.WriteLine("\n");
                            salary = displayModel.EmployeeSalary;
                            update = displayModel.IsUpdated;
                        }
                    }
                    else
                    {
                        Console.WriteLine("No data found.");
                    }
                }
            }
            catch (Exception e)
            {
                throw new Exception(e.Message);
            }
            finally
            {
                SalaryConnection.Close();
            }
            //return salary;
            return(update);
        }
        static void Main(string[] args)
        {
            Console.WriteLine("Welcome To Employee PayRoll Service!");

            EmployeeRepo repo = new EmployeeRepo();                                 //Declare Object for EmployeeRepo Class

            repo.GetAllEmployee();                                                  //Get Details for Employee

            EmployeeModel employee = new EmployeeModel();                           //Declare Object for EmployeeModel Class

            employee.EmployeeName = "XYZ";
            employee.Department   = "Management";
            employee.PhoneNumber  = "6302907917";
            employee.Address      = "12-AAAAAAA";
            employee.Gender       = 'M';
            employee.BasicPay     = 11000.00M;
            employee.Deductions   = 1600.00;
            employee.TaxablePay   = 2600.00;
            employee.Tax          = 1900.00;
            employee.NetPay       = 1500.00;
            employee.StartDate    = Convert.ToDateTime("2020-11-08");

            if (repo.AddEmployee(employee))
            {
                Console.WriteLine("Records added successfully");                                 //Adding Data to Table
            }
            int count = repo.GetInsertionsinEmployeeTable(employee);

            if (count > 2)
            {
                employee.EmployeeName = Console.ReadLine();
                employee.Department   = Console.ReadLine();
                employee.PhoneNumber  = Console.ReadLine();
                employee.Address      = Console.ReadLine();
                employee.Gender       = Convert.ToChar(Console.ReadLine());
                employee.BasicPay     = (System.Data.SqlTypes.SqlMoney)Convert.ToDouble(Console.ReadLine());
                employee.Deductions   = Convert.ToDouble(Console.ReadLine());
                employee.TaxablePay   = Convert.ToDouble(Console.ReadLine());
                employee.Tax          = Convert.ToDouble(Console.ReadLine());
                employee.NetPay       = Convert.ToDouble(Console.ReadLine());
                employee.StartDate    = Convert.ToDateTime(Console.ReadLine());

                if (repo.AddEmployee(employee))
                {
                    Console.WriteLine("Records added successfully");                               //Adding Data to Table
                }
            }



            ///   UC9_JustForImplication

            Salary salary = new Salary();                                                        // Salary Model

            SalaryUpdateModel salaryUpdateModel = new SalaryUpdateModel {
                SalaryId = 1, EmployeeSalary = 3000000
            };                                                                                                                    //Update Salary

            bool updatedSalary = salary.UpdateEmployeeSalary(salaryUpdateModel);

            if (updatedSalary == true)
            {
                if (employee.EmployeeID == salaryUpdateModel.SalaryId)
                {
                    employee.BasicPay = salaryUpdateModel.EmployeeSalary;
                    repo.AddEmployee(employee);
                }
            }


            //Console.WriteLine(updatedSalary);

            /*DateTime startDate = Convert.ToDateTime("01/01/2018");                                    //Get Data in the Range of Data
             * DateTime endDate = Convert.ToDateTime("01/01/2019");
             *
             * repo.GetAllEmployeeInGivenDateRange(startDate, endDate);
             */
            //repo.GetCountAvgMinMaxinEmployee(employee);                                             //Get Females Count with Max Min Data


            repo.RemoveEmployeeDetails("Indal", 8);
        }