public bool UpdateHR_ProvidentfundAmount(HR_ProvidentfundAmount hR_ProvidentfundAmount)
    {
        using (SqlConnection connection = new SqlConnection(this.ConnectionString))
        {
            SqlCommand cmd = new SqlCommand("UpdateHR_ProvidentfundAmount", connection);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@ProvidentfundAmountID", SqlDbType.Int).Value = hR_ProvidentfundAmount.ProvidentfundAmountID;
            cmd.Parameters.Add("@EmployeeID", SqlDbType.NVarChar).Value = hR_ProvidentfundAmount.EmployeeID;
            cmd.Parameters.Add("@EmployeeContributionAmount", SqlDbType.Decimal).Value = hR_ProvidentfundAmount.EmployeeContributionAmount;
            cmd.Parameters.Add("@CompanyContributionAmount", SqlDbType.Decimal).Value = hR_ProvidentfundAmount.CompanyContributionAmount;
            cmd.Parameters.Add("@PayrollDate", SqlDbType.DateTime).Value = hR_ProvidentfundAmount.PayrollDate;
            cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = hR_ProvidentfundAmount.ModifiedBy;
            cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = hR_ProvidentfundAmount.ModifiedDate;
            connection.Open();

            int result = cmd.ExecuteNonQuery();
            return result == 1;
        }
    }
    public HR_ProvidentfundAmount GetHR_ProvidentfundAmountFromReader(IDataReader reader)
    {
        try
        {
            HR_ProvidentfundAmount hR_ProvidentfundAmount = new HR_ProvidentfundAmount
                (

                     DataAccessObject.IsNULL<int>(reader["ProvidentfundAmountID"]),
                     DataAccessObject.IsNULL<string>(reader["EmployeeID"].ToString()),
                     DataAccessObject.IsNULL<decimal>(reader["EmployeeContributionAmount"]),
                     DataAccessObject.IsNULL<decimal>(reader["CompanyContributionAmount"]),
                     DataAccessObject.IsNULL<DateTime>(reader["PayrollDate"]),
                     DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()),
                     DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]),
                     DataAccessObject.IsNULL<string>(reader["ModifiedBy"].ToString()),
                     DataAccessObject.IsNULL<DateTime>(reader["ModifiedDate"])
                );
            return hR_ProvidentfundAmount;
        }
        catch (Exception ex)
        {
            return null;
        }
    }