public Payroll_Designation_Master findByDesingationID(int desinationID)
        {
            Payroll_Designation_Master designation = null;

            try
            {
                using (var db = new PayrollModel())
                {
                    designation = db.Payroll_Designation_Master.Find(desinationID);
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine("find designation error " + ex.InnerException);
            }
            return(designation);
        }
        public Boolean addDesignation(Payroll_Designation_Master designation)
        {
            Boolean status = false;

            try
            {
                using (var db = new PayrollModel())
                {
                    db.Payroll_Designation_Master.Add(designation);
                    db.SaveChanges();
                    status = true;
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine("designation add error" + ex.InnerException);
            }
            return(status);
        }
        public Boolean deleteDesignationbyId(int id)
        {
            Boolean status = false;

            try
            {
                using (var db = new PayrollModel())
                {
                    Payroll_Designation_Master designationmaster = db.Payroll_Designation_Master.First(b => b.Designation_ID == id);

                    db.Payroll_Designation_Master.Remove(designationmaster);
                    db.SaveChanges();
                    status = true;
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine("delete designation " + ex.InnerException);
            }
            return(status);
        }