public bool updatePayroll(Payroll obj)
        {
            string insertCommand = "update payroll set SalaryAmount=@SalaryAmount,BonusAmount=@BonusAmount " +
                                   " where  EmployeeId=@EmployeeId and departmentId=@departmentId ";
            SqlCommand command = new SqlCommand(insertCommand);
            SqlParameter idParameter = new SqlParameter("@EmployeeId", SqlDbType.NVarChar, 50);
            idParameter.Value = obj.employeeId;
            SqlParameter SalaryAmountParameter = new SqlParameter("@SalaryAmount", SqlDbType.Int);
            SalaryAmountParameter.Value = obj.SalaryAmount;
            SqlParameter BonusAmountParameter = new SqlParameter("@BonusAmount", SqlDbType.Int);
            BonusAmountParameter.Value = obj.bonusAmount;
            SqlParameter departmentIdParameter = new SqlParameter("@departmentId", SqlDbType.NVarChar, 50);
            departmentIdParameter.Value = obj.departmentId;








            command.Parameters.Add(idParameter);
            command.Parameters.Add(SalaryAmountParameter);
            command.Parameters.Add(BonusAmountParameter);
            command.Parameters.Add(departmentIdParameter);




            if (da.Execution(command))
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        public bool insertPayroll(Payroll obj)
        {
            string insertCommand = "INSERT INTO payroll (EmployeeId,SalaryAmount,BonusAmount,departmentId) " +
                                   "VALUES (@EmployeeId,@SalaryAmount,@BonusAmount,@departmentId)";
            SqlCommand command = new SqlCommand(insertCommand);
            SqlParameter idParameter = new SqlParameter("@EmployeeId", SqlDbType.NVarChar, 50);
            idParameter.Value = obj.employeeId;
            SqlParameter SalaryAmountParameter = new SqlParameter("@SalaryAmount", SqlDbType.Int);
            SalaryAmountParameter.Value = obj.SalaryAmount;
            SqlParameter BonusAmountParameter = new SqlParameter("@BonusAmount", SqlDbType.Int);
            BonusAmountParameter.Value = obj.bonusAmount;
            SqlParameter departmentIdParameter = new SqlParameter("@departmentId", SqlDbType.NVarChar, 50);
            departmentIdParameter.Value = obj.departmentId;

         






            command.Parameters.Add(idParameter);
            command.Parameters.Add(SalaryAmountParameter);
            command.Parameters.Add(BonusAmountParameter);
            command.Parameters.Add(departmentIdParameter);
         



            if (da.Execution(command))
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        public bool deletePayroll(Payroll obj)
        {
            string insertCommand = "delete from payroll  " +
                                   "where EmployeeId= @EmployeeId and departmentId=@departmentId ";
            SqlCommand command = new SqlCommand(insertCommand);
            SqlParameter employeeIdParameter = new SqlParameter("@EmployeeId", SqlDbType.NVarChar, 50);
            employeeIdParameter.Value = obj.employeeId;
            SqlParameter departmentIdParameter = new SqlParameter("@departmentId", SqlDbType.NVarChar, 50);
            departmentIdParameter.Value = obj.departmentId;


            command.Parameters.Add(employeeIdParameter);
            command.Parameters.Add(departmentIdParameter);

            if (da.Execution(command))
            {
                return true;
            }
            else
            {
                return false;
            }

        }
        public Payroll GetAllPayroll(string eid,string did)
        {
            Payroll pn=new Payroll();
            string query = "select SalaryAmount,BonusAmount  from payroll where EmployeeId='" + eid + "' and DepartmentId='"+ did + "'";
            SqlCommand cmd = da.GetCommand(query);
            cmd.Connection.Open();
            SqlDataReader reader = cmd.ExecuteReader();

            while (reader.Read())
            {
                pn.SalaryAmount = reader.GetInt32(0);
                pn.bonusAmount = reader.GetInt32(1);

                
                
            }
            return pn;
        }
        public List<Payroll> GetAllPayrollListEmployee(string eid)
        {
            List<Payroll> payrollList = new List<Payroll>();

            string query = "select employeeId,SalaryAmount,BonusAmount,departmentId from payroll where employeeID='"+ eid +"'";
            SqlCommand cmd = da.GetCommand(query);
            cmd.Connection.Open();
            SqlDataReader reader = cmd.ExecuteReader();

            while (reader.Read())
            {
                Payroll p = new Payroll();
                p.employeeId = reader.GetString(0);
                p.SalaryAmount = reader.GetInt32(1);
                p.bonusAmount = reader.GetInt32(2);
                p.departmentId = reader.GetString(3);

                payrollList.Add(p);
            }
            return payrollList;
        }